I actually finally bought and played NWN2 and it's main campaigns back in... shit I have to look on GoG Galaxy... 2019. It was pretty good actually, I enjoyed it. I honestly didn't expect it to be as buggy as it was because I figured everything would be resolved by that time, but it was still pretty buggy. Playable though. Worth the play through.
It was definitely missing the magic of the first game for sure. But I still really enjoyed the campaigns and SoZ was interesting and fun as well. I feel like the Acquisitions Incorporated supplement for 5e probably shares some things in common with that one.
I tried downloading some modules that people made, and found some recognizable names from NWN 1. I got so far into one module before I had to quit, it got too buggy and unplayable. I don't put the fault with the creator either, I'm sure it has a lot to do with NWN2 still being buggy at it's core. At least the campaigns are playable though.