I still play Neverwinter Nights 1 and I still put stuff together on it. I'm going to wait till I get a new PC before I get NWN2, and besides.. there's so much cool stuff to toss into NWN 1 that it'll keep me occupied for ages.
I recall that some team of modders was working on converting NWN 1 into a Shadowrun (one of my favorite old pencil and paper RPG's) environment called Shadowrunner Nights. I last heard about it a year or so ago and don't know the status of it. It could have vaporised but then again, maybe not. We had to wait for like 3 years for the Community Tileset Pack.
Anyway.. this is the best site out there for content and addons for NWN 1 and 2.
http://nwvault.ign.com/