Fedora has come a long way in the past 10-15 years. It's a very stable GNOME workstation distro that tends to use bleeding-edge stuff. They also have some neat ideas (like Silverblue) that are fun to play around with.
I've also found dnf/yum to be overall nicer to use than apt, the history feature is especially useful too.
10-15 years ago i tried Red Hat / Fedora and it wasn't great. I than also tried debian and it just worked and was easy to use.
Now, i'm not looking for support much. I prefer the base stability of debian/ubuntu. Haven't looked into RedHat a long time and i also don't see any big reason for it.