I think mod sites should host all mods, even ones they don't agree with, so long as the mods in question are not breaking any sort of official law.
And yes, that includes mods even I personally don't care for.
The point is that what someone does with their game is none of my business and does not affect me in any way.