I don't use red hat based distro myself so I'm curious: if you want to run an old binary built for, say, RHEL from 5 years ago, can you run that binary on centos stream without dependency issue?
One thing that I like about RPM is how most packages specify dependencies based on contents, not on package name or version. So, even if a package changes name, if it still contains the required ".so.x.y.z" library, it will work.
PS: I don't understand how people can complain about rpm/yum/dnf, 20 years ago it was already years ahead of what apt/deb is today.