I have the opposite oppinion.
I want players to be ready when they join the campaign and have all the mods preloaded so we can start playing right away.
They have to download them to begin with anyway, so I fail to see the problem with a bit of player-side preparation.
An "autoload" feature would be convinient when playing with "randoms", but I doubt that will happen a lot.