Why the thread didn't have much activity since 2012 is simple, I forgot that I've had posted in this thread.
I just wanted to mention another non TW-community site and that's The Assimiliation Lab (TAL).
Main Page: http://www.theassimilationlab.com/
Registration: Required for uploading, not required to download
File Size Limit: 6 GB
Download Counter: No
File Retention Time: ?
URL Upload: ?
Other Comments: No ads before downloading and no pending process similar to what ModDB has
However, since I play Total War games and TES games the founder on TAL agreed to allow uploading and re-uploading TW mods, in fact TAL also offer mirroring of other game mods and TW mods.