I'd say they are definitely worth it. I have 31 mods running and never had a corrupted save, so far, & the game's performance isn't negatively affected most of the time.
Nexus has a scratch for almost every itch you can think of, it really depends on what you are
looking to change. Personally I cherish those mods that fix tedious game play mechanics
like mass farming, quick deposit and build from containers. Others that I wouldn't want
to miss anymore are Equipwheel, Glutton and auto fuel. Equipment & Quick slots
deserves to be mentioned, but unfortunately that mod has issues (you might lose your
stuff). I might have quit the game after defeating the Elder, hadn't it been for "Passive
Forsaken Powers".