The poster mentions having gone to the Vault already, so the question's not where to find modules, but which of the newer ones do people really enjoy.
The Neverwinter Nights Podcast does review modules, but it's not really a list of top modules. But since I can post links, here's the link to the podcast mentioned above:
http://www.nwnpodcast.com/nwnp/
I don't think there's any place dedicated to reviewing modules anymore, so that wouldn't help for newer modules. On the other hand, the
Academy of Modding excellence discusses, reviews, and votes on new modules as they come out, but you can only read them or participate in them if you offer to help with the voting and nominations.
So, I'll just mention some new-ish ones that I liked.
Wulverheim is a nice open-world sandbox type game that takes a lot of inspiration from Oblivion in terms of the town hubs, questing, buying houses, and it's very large. It used to be a PW, but it was released as a single-player module maybe 2 years ago, maybe less.
Fanglewood is a module from last summer, that I thought was fun, and a good length. It provides companions for hire, for your party.
Shaar Moan is a short comedy adventure in an undead crypt. I thought it was a lot of fun. Many "Thriller" references.
