Quote Originally Posted by FactionHeir
As for NWN, I've played it for ages and help run the nwnwikis, but the SP campaigns are not too recommendable, except for the HotU one. There are countless modules which provide many hours of gameplay and indeed play as if they were a whole new SP campaign.

Can't really go wrong with these.
I agree about the official SP expansions, but aren't those needed for at least some of the user-made modules, for the included background tile sets and creatures? I seem to remember a few that worked that way, and the original tiles did get a little boring after a while (same reiteration of town streets, castle interiors, etc.). So it might be a good idea to pick up those official expansions even if you don't play them all.