I just read this stickied post on the Bioware forum, where most of the NWN2 conversation goes on. This has a lot of useful information and links to where to find various content. It may be a little out of date, but a good starting point.

http://social.bioware.com/forum/1/topic/172/index/5688433