Well, what do you know, I've changed my mind. NWN2 actually IS fun as long as you accept it for what it is. I realised it was actually my fault that I haven't enjoyed the game:
1. Having played through The Witcher recently I guess I got spoiled. While the combat and character development in TW is certainly nothing worth mentioning, the story and the setting kept me glued to the computer. Switching to NWN - style blandness apparently hurt me in the beginning. Some time have passed and suddenly I stopped caring about story that much and had fun with combat, loot and chardev. I also stopped caring about the graphics and the voices. TW got both realistic, while NWN2 is, well, high fantasy. It took me some time to adapt from a "I'll fucking kill you" TW thug to a "You're in trouble!" NWN2 thug.
2. Something was definitely done with the camera. While it's still nothing stellar, after installing SoZ it definitely got better. The party AI also got better, though I still turn off spell-casting completely so that the druid bitch won't hurt half of my party with that call lightning. Also (after installing MoTB or SoZ, I'm not sure) a party select key appeared which alleviated most of the management problems for me.
3. I created a boring character earlier. While a warlock/warrior would certainly be fun to play in the PnP version it wasn't in NWN2. Now I've got a wizard/eldritch knight, and development is much more interesting.
4. NWN2 is much better than NWN. Story's better, no more of that "go to E,W,S,N from the chapter's hub and collect four important artifacts" and other crap which NWN got it's infamy for. I'm also pleasantly surprised that the game has some decent peaceful resolution options, though the skill checks could be more brutally enforced - I mean, I failed BOTH diplomacy and bluff checks in the lizardmen caves and still I could persuade them to cease fighting through mundane dialogue (though IIRC, if you fail a skill check in the first lizardmen cave near West Harbor, you get to fight no matter what you say).
The combat is much more strategic and sometimes it's challenging. I started MoTB for a moment to get a taste of the story, entered the Veil Theater and got my ass handed to me by the pair of wizards (Safiya killing my main chara with meteor storm didn't help).
The game's decent, even the OC. Nothing spectacular, I'd say it's the FO3 of DnD RPGs - as long as you concentrate on the things the game does well and stop comparing, you'll enjoy it. I think I'll write a review of the OC when I'm done with it.
Ad1. Installing SoZ got the OC to do some really funny things. For example, Daeghun after saying "So many years ago, today" does a strange theatrical pose, and when saying "my foster child is dressed" he's thrown off the game world for a while. These are bugs but they increased my overall enjoyment of the dialogue immensely ;> Hope the latest patch didn't fix this.