Baldur's Gate : The Sword Coast Chronicles : NWN2 Persistent World

I hear that pretty much all the glitches I hate about Warlock have been fixed for this server. I'm playing through the single player OC/MotB campaigns at the moment as a melee Warlock and want to include those fixes. Specifically the rebalance for the spell penetration glitch and the fix that applies Hideous blow to the first attack in the round (rather than counting it as an interruptible single spell that takes a full two rounds to use on each blow).

What/where can I download mods to incorporate those changes to my single player campaign?

Nowhere I'm afraid, the code the server use is not publically available and it would need some work to pick up the parts you need. However the bugs you're talking about are known ones and you should be able to find the fixes to your problems on https://neverwintervault.org with a bit of search.

I've done a little looking on there, and unfortunately the main fix mod was "Warlock Buddy" which never got updated for the coding in SoZ, and therefore doesn't function.