I tend to go minimalist on most mods, unless they dramatically improve a game. As soon as I start to run into technical problems, I just stop using it for a few months. If I'm still playing the game a few months later, and I browse through the workshop and see the mod, I might click on it just to see if it's been updated.
For me, the trick to maximizing enjoyment of mods is to apply the 20/80 rule. 20% of the mods I might want to use will deliver 80% of the improved game play out there. When I try to get 100% of the improved game play out there, I just find myself at the bottom of a perfectionist doom loop where I spend so much time trying to perfect the game that I don't get any time to play it!