AlmaLinux 8 is the best foundation for a new server. AL9 is beta quality, mostly ready for production (with just a few known bugs -- such as CWP Migration does not work). Rocky Linux is more of a "rocky" experience -- incompatibilities, missing libraries, etc.