Well, finally, i'm getting rather sick of the regular Neverwinter Nights campaigns, and it's rather difficult picking out the gold of NWN modules. Far too many being mindless hack and slashes, so post your favourite NWN modules.
I'll start right off
The Elegia Eternium Series is probally my favourite modules. Complete with custom voices and hack packs it delves far deeper into the role playing aspects, in fact there is very little combat in both modules. And the plot is dark... very very dark.
There are currently two modules in the series.
EE1: Elegia Eternium
EE2: Excrucio Eternium