If we take stability as a parameter, is it safe to match them like this?
Fedora --> Ubuntu
CentOS Stream --> Ubuntu LTS
RHEL --> Debian
I know that CentOS stream is more kind of a rolling release but... feels like an LTS distro in practice... or it is just me?
Edit: adding some context.
I am planning to setup a dev machine that I will connect to remotely and would like to babysit very little while having stable and fresh packages.
In the Ubuntu world we would go to an LTS release but on the RPM/Dnf world is there any other distro apart from CentOS Stream?
And also is CentOS Stream comparable to an LTS release at all considering that they do not have release number?
Beware that it's immutable-ish, so you may have to retrain your brain to think in containers/layers. It's one of my favorite ways to do Linux, though, and I don't think I can ever go back.
If it doesn't fit, you could look into how you can roll your own based on an upstream image and booting from a distrobox or podman container.