Sorry I know you can google this but the information out there for this game is massive and often from several years ago.
So having said that, as a newcomer to the franchise, what are the best mods to improve the vanilla experience, IE bugfixes, texture/graphics overhaul. Possible rebalance of weak classes and the like?

Im just about to start myself.
I only applied gui and gfx mods.

All the community bugfixes i've found in the net seem to predate the latest version of NWN2 complete edition so they even might do more harm than good.

These are the mods i've Installed:

Divine GUI Remake
https://neverwintervault.org/project/nwn2/other/gui/divine-gui-remake

NWN2 Facelift Pack
http://www.nexusmods.com/neverwinter2/mods/212/?

All NWN2 Terrain Re-bumped-mapped
https://neverwintervault.org/project/nwn2/images/texture/all-nwn2-terrain-re-bumped-mapped

All NWN2 Grass Desaturated with Added Detail
https://neverwintervault.org/project/nwn2/images/texture/all-nwn2-grass-desaturated-added-detail

Floorboards (Hi Rez & Bump-mapped)
https://neverwintervault.org/project/nwn2/images/texture/floorboards-hi-rez-bump-mapped

Real Paving Stones, Kerbs/ Curbs & Bricks
https://neverwintervault.org/project/nwn2/images/texture/real-paving-stones-kerbs-curbs-bricks

Real Oak and Mahogany Textures (Hi Rez & Bump-Mapped)
https://neverwintervault.org/project/nwn2/images/texture/real-oak-and-mahogany-textures-hi-rez-bump-mapped

Neverwinter Cobble texture (Hi Rez & Bump-mapped)
https://neverwintervault.org/project/nwn2/images/texture/neverwinter-cobble-texture-hi-rez-bump-mapped

All Bracers, Pauldrons, Greaves now Shiny, Retextured & re-bumpmapped
https://neverwintervault.org/project/nwn2/images/texture/all-bracers-pauldrons-greaves-now-shiny-retextured-re-bumpmapped

All NWN2 Cloaks Retextured (Hi-Res & Bumpmapped)
https://neverwintervault.org/project/nwn2/images/texture/all-nwn2-cloaks-retextured-hi-res-bumpmapped

Credits and thanks ofc go to all the respective modders for all their hard work.