How about github as a host alternative to the virus magnate mediafire, for small mods (<50MB)? Would make mods easily hostable as a .zip file for those who want to use it, and make mods easily searchable for other modders trying to figure out how to do stuff. Issues and Wiki could even be disabled as part of the terms of using it. The links advertised in the paradox forums could be direct download only, or if you permit a link to a gh_pages page which can be automatically generated from the github project.
Mediafire and it's ilk probably won't survive the TPP treaty, and even if that treaty gets mothballed the megaupload-like sites surely have their days numbered.
EDIT: I may have been too judgemental about mediafire, they seem to have changed a whole lot since the last time I dealt with them. Still think github could be a terrific alternative.