What you should keep in mind is exactly how long it takes to create a PW-sized module for NWN 1. From what I hear(don't ask), it'll be very similar to NWN 1 module-making in 2, but with room for improvements for those who want to improve. In all probability, it'll be a while before you see many full-on NWN 2 PW modules, even after NWN 2's release.
I think you'll see a good few months where NWN 2 is available with very little custom content. I fully expect a lengthy transition period, exceeding even that of CEP servers. The hefty graphics engine upgrade will only make that transition longer, since a good portion of the player base might be unable to run the game at first.
All in all, it's way too early to even guess what'll happen, since there's entirely too many variables about NWN 2 that aren't being commented on just yet.
As far as NWN 2 aiming to "cash in", I'd have to say don't worry. Not only are many key parts of the game being openly discussed with fans, but there are MANY fans who have been taken on as staff-members for the development of the game. They also seem uninterested in unjustly hyping the game; they've come right out and said many things will simply not happen, such as the z-axis. Such honesty usually indicates that there's not much to hide, or worry about. Also, there's no Lucasarts to unjustly rush the game to the shelves this time around. (blatant KotOR 2 rip)