And the crowd said, "Bo Selecta".
You're talking nonsense. Because you upgrade with an automated tool that is guaranteed to not remove superfluous libraries, you're pretty much guaranteed to end up with stale, unused libraries on your system.
How do you GUARANTEE that such a such a situation does not occur in your oh-so-tight system?
Oh, balls to this.
You can't. That's it; it's that simple. There's no tool for doing this on RPM-based Linux distributions. It's down to you going "rpm -qa", parsing the results, and figuring it out for yourself.
On the other hand, there is a tool for doing this on Debian-based distributions; it's called "deborphan" and it removes libraries and packages (as you see fit, natch) that nothing depends on.
In fact, in order to ensure that one's system remains "tight" (whatever the hell that means - on the one hand, you're spectacularly anal about what kernel modules are available, on the other you don't appear to give a shit what's strewn about the filesystem) there's an even better tool - "debfoster". debfoster removes packages and everything that they and they alone depend on. I'd have thought such things would appeal to your silly sense of "tightness", but now that you've backed yourself into the "Debian is shit! I think it, therefore it's true!" corner, you'll never be able to use them (at least, and admit it).