Probably a lot of redundancy but it's a topic that pops up every few years (and these are just all the ones with more than 5 responses):
https://rpgcodex.net/forums/threads/recommend-me-nwn-1-modules.148609/
https://rpgcodex.net/forums/threads/best-player-made-nwn-campaign-modules.147539/
https://rpgcodex.net/forums/threads/neverwinter-nights-nwn-nwn2-modules-thread.34529/
https://rpgcodex.net/forums/threads/recommend-me-nwn-1-modules.148609/
https://rpgcodex.net/forums/threads/best-player-made-nwn-campaign-modules.147539/
https://rpgcodex.net/forums/threads/neverwinter-nights-nwn-nwn2-modules-thread.34529/
Some were good, others not so much.
Is it really that good of a show?