I liked it, and I played it. Some of the NPC's that are your henchmen have some great dialogue (Khelgar, Neeshka), but the ending is rather weak. However, I think the production team had a sequel in mind.
The expansion, which will come out in the fall will be called Mask of The Betrayers, and supposedly picks up after the ending of NWN2. It will be interesting to see how the main character gets out of the ending of NWN2.
If you do get the game, make sure you have at least 1+ gig of RAM, and a decent video card. I have an nVidia 7300, and still it was choppy in some areas.