I have not been able to find a way to prevent this. Its baked into the modding code and workshop integration I think. Any subscribed mod that is updated will be automatically downloaded by Steam. It then enables it for you just like a new subscription.
There is nothing in the modding.lua script that does this so I can only assume its part of the unexposed codebase Firaxis has yet to make available to modders.