Single-player campaigns will also have mod conflicts. i.e, if two mods change the same thing about something (such as modifying a player class or a terrain set) you'd need to log into steam to manually disable and enable each mod just to change campaigns...
Not if mods can be enabled/disabled through the ingame menu like D:OS 1
