Some people have actually had good luck with Oracle Linux but that’s very much an individual (or corporate) choice to consider.

Aside from that, Rocky Linux also seems like a great choice for many: https://rockylinux.org/

Some also say that AlmaLinux is pretty good: https://almalinux.org/

Personally, I found RPM distros to be quite stable but have largely moved over to Ubuntu LTS for servers (technically Debian also has a LTS release, but it’s not as mainstream) and Linux Mint locally (largely Ubuntu without focus on snaps and the Cinnamon desktop is pleasant), it’s been working pretty well so far.

Then again, I run most software in Docker containers, so thankfully underlying OS changes usually aren’t too bad for me to deal with.