I currently use Rocky on all of the servers I personally maintain for Virtualmin and for my personal stuff (I have to use Ubuntu for my other job), as I’ve mentioned several times.
I don’t have opinions yet on the future, as it hasn’t happened yet. I don’t know what will happen with Rocky and Alma. We’ll have to wait to see. I prefer RPM and dnf over deb and apt, and I think Ubuntu makes a lot of dumb/erratic decisions, so I have a preference that I’ve never been secretive about. But, we’ll see how it shakes out.
RHEL isn’t really an option for most people doing web hosting on a small scale, it’s just too expensive, so if there is no free enterprise style Linux going forward, it will no longer be the dominant OS in hosting at the scale Virtualmin mostly operates in (if it even still is…we have more users using Ubuntu than Alma+Rocky+RHEL these days).
CentOS Stream is probably not an option for small software makers like us, since we don’t have the resources to track a constantly moving target. And, I don’t get the impression it’s been very popular in shared hosting, anyway.
But, I don’t know. I don’t have any solid answers for you, until we know what’s going to happen with Rocky and Alma.
From a business perspective, I should be enthusiastic about being able to reduce the number of distros we support. If Red Hat kills off EL in the hosting space, I at least get to spend less time on supporting so many damned operating systems. 