The whole Steam Workshop integration is just shockingly badly coded - players "don't get it" (most click Back after enabling mods, believing the Single Player menu option is a heading above the list of mods they have enabled to play with) and then blame the mod for being "broken".
For others, the game - whether in off-line mode or on a "dodgy" intenet connection - will intermittently delete mods; code should NEVER do that without some form of user confirmation. Imagine the outcry there would be if IE/FireFox deleted cached files (including cookies) everytime it went into offline mode! For some, the download will happen but the install won't - the state/event system gets out-of-sync when the network disconnects and just can't recover. The latest patches were supposed to fix the connection issues (the first just made them significantly worse) - but they don't.
It's a lot less stress for me to walk away from the Workshop (and remove over 10% of the mods on there - which Firaxis probably won't notice and/or care about) than it is to continue taking the flak for Firaxis poor code.
W