Any LTS is good for reliability. RHEL clones are pretty good just depends on what someone is looking for.

Edit:
For an actual reason, mainly for the length of the LTS as rocky and alma I believe have a 10 year LTS while Debian have a 5/6 year LTS (sorry if that’s wrong, haven’t checked the length of the LTS in a while)

I’ve currently been running tumbleweed for the past 2 years, has been pretty solid.

I’ve tried out a couple distros and my takeaways are if you want stability, go with an LTS (leap, rocky, alma, devuan etc) and if you want newer packages on top of that you could use something like nixpkgs or build from source for the packages that aren’t there yet.

If you want the latest packages/you do gaming or your hardware is pretty new, a rolling release like arch/artix is probably your best bet.

I just prefer tumbleweed as it comes with some useful stuff preinstalled out of the box. For instance, if I’ve ever had a bad update I’ve always used snapper to roll back as its preconfigured when you use btrfs