Baldur's Gate 1 & 2 have excellent mods too (EasyTutu, etc).
I never bothered with NWN & NWN2 mods... these games are terribly boring imo (at least the official campaigns). When it came to Bethesda games I merely used mods that improve the user interface and a few face/body mods. Usually it's too much of a hassle to get them to work.
I thought NWN: Hordes of the Underdark and NWN2: Mask of the Betrayer are some of the best PC RPG expansions around -- better than the campaigns found in their original game.
Though, BG2: Throne Of Bhaal has to be the best RPG expansion I've ever played.