Leroux: New wave of single players perhaps, not so sure about modules. They take a lot of time and effort to build, and people willing to go to such lengths for a 16 year old game and just for fun aren't magically appearing out of nowhere.
People still make mods and campaigns for Doom and Freespace 2, both of which are older than NWN. Also, there aren't really a lot of other games with toolsets like NWN's. In fact, there are none. Believe me, I've looked, because I've really been wanting a game with NWN's moddability combined with full party control. NWN is still unique in the world of moddable RPGs. If it gets a singleplayer revival, I think it will lead to more modules being made,
especially with the new possibilities FPC would offer. NWN's "henchman" system has really been a hindrance to module design. You basically have to design modules to be completable by brute-forcing them with any class. For the most part, you can't make anything that requires actual tactics, because the player doesn't have the necessary control. If that limitation were removed, it would be a whole new world for module design.