I think it depends on the mod. I think that visual mods can be done in mid-game but anything dealing with the campaign map you cannot load a mod in the middle of a game.