This thread was brought to my attention via an act of necromancy, so I don’t know if there’s still a soul in it or whether it should have stayed buried, but …
As for me, I explicitly check the Vault for new modules from time to time, and even though I took a long hiatus from playing NWN I was recently drawn into it again, so the chances of me playing freshly released modules have increased.
I don’t play everything that’s released though, it needs to catch my attention when I’m browsing the list. In the OP’s case I’d probably be curious already because I recognize the name Chris Huntoon from having played some of their modules in the past. In general though, I think, the presentation of the Vault page for the module shouldn’t be underestimated. My observation is that authors who care a lot about their work and release very polished and meticulously crafted modules also set store in making the Vault page as informative and nice looking as possible. If there are no screenshots and the information on the page is extremely basic, just a couple of trivial sentences, I’m likely to give the module a pass, expecting it to be just as bland and basic. Likewise, if there are walls of text to read through, I give it a pass because I expect the module to be just as verbose and not on point.
So there is still some interest in new modules and the fact that a module is freshly released can work to its advantage and draw attention to it, but it needs to stand out somewhat and lure players in with a nice presentation as well, I think.