So, after getting into NWN with community modules, I went back to some of the official content.
** SPOILERS FOR OFFICIAL CAMPAIGNS BELOW **
After a disastrous first impression, the OC turned out to be surprisingly serviceable. While the cringeworthy tutorial and premise (let's hire level 1 characters to save the world) are awful, and not helped by being pushed to do the absolutely terrible prison area first, the rest was actually entertaining. Lots of little side stuff to do in each area, some decently sized wilderness, and a decent epic vibe buildup with the creator race, etc. Obvious twists are obvious, of course, but still. Think the only thing I really missed were the underground ruins under Luskan. Didn't manage to find the key to the door in the house leading to them. Oh, and the henchmen quests because they seemed super boring, the AI is shite and I don't like sharing my xp.
SoU started a bit in the same way but soon felt more on rails. In a nice way though, each linear segment not overstaying its welcome, and enough of them to keep things moving. Kobolds were entertaining, and I enjoyed the switch to the desert afterwards. Also, that cult of Ao...
Unofficial here, but I did The Nether Scrolls there as it closes up some story gaps between SoU and HotU. Felt like a good idea, and well, can't complain. Combat-focused, but similar feel as SoU with lots of bite-sized linear sections. Did close the gap and explain that reaper thing which would have been otherwise jarring in HotU.
Then HotU, and I have mixed feelings. For a start, I always found the whole premise of the Yawming Portal a bit stupid, so starting there, well... After that, while I appreciate that it's entirely consistent with what the Undermountain is supposed to be, the whole cliché dungeon that makes no sense apart from being an RPG dungeon was meh. Thankfully it's only floor 1 that goes down that road, and well, it was over soon enough in the end. Retrieving my items from SoU was nice at that point, but it was... so... tedious... to have to sort out inventory once again (more on this later). Chapter 2 surprised me as I generally dislike the underdark. But the various sections were actually ok, and Nathyrra was interesting. Valen (?) seemed like a twat from the start so didn't pick him up. Was a bit annoyed at skipping the Isle of the Maker: I finished the army-weakening part first and got force pushed into the big battle, where I proceeded to ignore the troops to mow down the enemies by myself. Great Cleave is hilarious. Roll on Chapter 3, and we're back in meh territory. Cania started well enough, but then it's boring planeswalking in linear and uninteresting gimmick areas. Had fun exploring the various endings though, so there's that. Surprised by Nathyrra not having some twist, she was... just nice... Expected something more from the Lawful Evil alignment, it just doesn't seem to fit her repented persona. As for Aribeth, sheesh, she's a speed dater isn't she? You barely met her she's already making passes. Have to say I lol'ed at her comments in the mimic section. Some nice conversations providing a bit more context to the OC too.
So overall, I'd put OC/SoU together as rather ok, and HotU as a bit below that due to less open areas and some more tedious linear sections.
For other official stuff, I've also been through Kingmaker, which was ok but ending just when it felt like it was going to open up, and Pirates of the Sword Coast which was genuinely entertaining and rather creative (the shipwreck salvaging, the treasure maps...). Using the OC docks district map was a nice touch too. Only downside is that the Pirates character is hardly reusable due to the various buffs you get shortly before the end. Pity because it's a nice 1-11 option otherwise.
On a more general note: the encumbrance system is a mess. It makes it disproportionately more convenient to have a STR character. While player-made modules mitigate that with generous access to bags of holding, the official campaigns are pretty skint on these (HotU is just awful bag-wise). And even with lots of bags, the old "strip character from all items" trick becomes a massive pain when you find the gear back and have to reorganise everything into bags...