Well, I know I didn't fancy it, but on the other hand I could never figure the NWN toolset out, either. I just plain suck at modding.
There are a ton of things made for NWN2, from campaigns to objects & scenery. A small team even remade the original Baldur's Gate in the NWN2 engine, which is a pretty stunning feat, IMO.
The best places to find NWN2 stuff are:
Neverwinter 2 NexusNeverwinter VaultThe Neverwinter Vault has moved recently, BTW, so if you knew the old location, it's gone.