Let's be real here though, Terraria is an unfair comparison considering it's modloader is integrated into the game itself and holds significantly greater support than most other mods with Steam Workshop support. (Oh and that the modloader is basically a community made mod manager anyways and is akin to using the community mod managers for the games mentioned below)

Stellaris, Rimworld, Divinity: Original Sin 2, Total War: Warhammer 3, Binding of Isaac, Dwarf Fortress, Space Engineers, Cities: Skylines, all of these very popular games with massive modding support are still plagued by the issues I mentioned above. And you know what? It has the issues you mentioned as well. Did you subscribe to an outdated mod? Oh, well, good luck figuring out which one that is. Forgot to download a dependency? Crash. Did a mod update and Steam just didn't update the mod? Figure out what mod that was and unsubscribe to it and subscribe to it again. Did a mod just update and Steam updated the mod, even though the update breaks save compatibility? Well, unless the mod author uploaded the older version of the mod, good luck trying to have fun.