We're primarily a CentOS (6/7, kill me) and Rocky 8+ shop at work, with Debian handling our webservers. ~~My Boss~~ We like Rocky so much, it's even our base image for all of our containers (ugh).
My experience so far is that RHEL (and derivatives) are pretty solid, and not a bad choice. Though, I'd generally want to avoid the complexity that is SELinux in selfhost endeavors.