This review is only about nwn2's main campaign (MC).
From a first glance, it's a quite decent game, given it's a 2006 game and honestly quite well developed even though far from perfect. As an rpg game the variety of classes, deities, skills, etc is greatly expanded, which means you can build pretty unique characters on every alignement you want.
The storyline, as the title suggests is somewhat peculiar. There are many cliche parts, I 'll avoid elaborating as I prefer the review to be spoilless, but If you try the game it's quite easy to tell; and on the other side, there are plenty of interesting quests especially in the mid game which I honestly loved and stayed full focused.
I didn't really like the companion characters personally, I felt they were scewing to the "good" side on average and that makes the campaign kinda disappointing if you want to go as an evil character. The rectifying part was that the evil characters were clearly better developed so maybe that balances things out.
Now, obviously dnd rpg games are not from everyone as If you want to play the game on hard or very hard difficulty you have to pause and strategise every single second of the fights, which can be preferable for some players but certainly not for the majority. So I would suggest this game mostly for the storyline rather than the battle element.
Overall it was a great experience and If you manage to finish it, it is a mandatory to go for the expansion sequel Mask of the Betrayer where the level is hugely elevated.