Depends. Are you talking about NWN1 or NWN2? Mods in turm of graphics/etc or new modules/companions?
For now I'll talk about mods
If NWN, check here
https://lilura1.blogspot.jp/p/nwn-utility-visual-mods.html I personally use NWNCX, NWNCP, Henchman AI and Progect Q for graphics. All mentioned there.
If NWN2, check here
https://lilura1.blogspot.jp/p/neverwinter-nights-2-mods.html My setup is NWN2 Facelift Pack, Tchos' HD UI panels and dialogue compilation and expansion(usefull for high resolution displays), Tony K companion and mosters AI(let you turn puppet follow with pause every round, also makes enemies more clever) and Kaedrin Prc Pack, but the last one is not very compatible