The "Official" campaign is on the weaker side, but the toolkit of NWN and its resulting decades of community-made campaigns and modules will serve up thousands of hours of delectable D&D 3rd Edition goodness. The expansions and pack-in Premium Modules are a great place to start, giving a solid ground to build on for everything from old-school throwbacks to mini-stories, classics like Swordflight to weirdness like A Dance With Rogues. The Enhanced Edition has some multi-player fixes and a few mechanical/graphical updates, but the Diamond edition is perfectly sufficient.
I really, really wanted to like this one but there was so much getting in the way of that. Weird dialogue carried by even weirder voice acting. Glacial, over-stuffed plot. Tabletop RPG bits that do nothing except *remove* parts of your investigation. A system of choices that, by the end, practically begs you to spoil the game by looking up a wiki so you can make sense of it. If you're really a diehard of Lovecraft or the many, many, many cursed IP's derived from his work, try it out on deep sale. Otherwise, just play The Sinking City instead.