This is kind like a poll. If you were to use DNN to host your site, what kind of modules, in terms of functionality, would you like to use (beside the modules which come with DNN)?

And what kind of modules do you think are really missing in DNN?

Here's that recent "Top 10 modules" thread (hey, Salama already posted in that thread...)
  http://www.dotnetnuke.com/Community/Forums/tabid/795/forumid/118/threadid/285016/scope/posts/Default.aspx

DNN already have a great sampling of most modules you'd want but some third-party modules simply do things better than the core ones (though most core mods continue to improve thanks to the DNN project teams).

 
Regarding a module that DNN does not provide:  
I think the biggest missing piece at present is a custom forms creation module (such as XMOD, Dynamic forms, H2O, etc).  Beyond that would be social mods (Smart Thinker) outside of the basic Forum and Blog modules.

-mamlin

Your response got me wondering, so I checked SC's current "Top 10" modules since I also think that the list is a decent indicator of what people may find missing/lacking in the core modules. 

For what it's worth:  Three of the current "Top 10" are (or include) custom form builder modules.  The other seven are alternatives to modules already included in DNN.