Here are some notable sites and blogs of nwn2 module authors.
http://adamandjamie.com/nwn2/
Adam Miller's Dark Water nwn2 site.
http://www.roguedao.com/PlanescapeTrilogy.html
Rogue Dao Studios' Planescape Trilogy
http://www.forgottenrealmsweave.org/wiki/tiki-index.php
The Forgotten Realms Weave wiki: "To allow builders to create coordinated campaigns set in the Forgotten Realms while retaining a high level of autonomy for their individual projects."
http://www.nwcitadel.com/blog/index.php?blogId=5
The Rusty Spike
Jaks design diary of sorts for his upcoming NWN2 DM led campaign.