Today, June 30, 2024, support for CentOS 7, one of the most popular versions and still used on almost 26 percent of web servers, ends. I have always appreciated RHEL-based distributions for their stability, and my favorite has been CentOS 7 itself. No operating system has ever given me so much security and so few problems.
In the server area, I prefer CentOS, while for the desktop I have always chosen distributions derived from Debian, such as Ubuntu. However, the latter, being derived from the "unstable" branch, are not stable enough for use on servers. For this reason, CentOS Stream cannot be a viable replacement for CentOS, and the same goes for RHEL, due to licensing costs that are too high for use on web servers. However, the community has presented viable alternatives, of which my current favorite is AlmaLinux, although I am less familiar with Rocky Linux and Oracle Enterprise Linux.
I cannot say today which is the best alternative. Certainly a web server can also be built with Debian-derived versions, such as Ubuntu 24.04 LTS, which I currently use on some cloud-based VPS and which has not given me any particular problems.
My preference for RHEL-based distributions is perhaps due to habit and knowledge gained from years of use. I entered the Linux world precisely with such distributions, including SuSe Linux and Fedora, mainly in the server environment. For the desktop, due to issues of program compatibility, I was never able to abandon Windows as the main system.
Unfortunately, CentOS is leaving us. This is not the first time that open source projects undergo changes; sometimes, these lead to significant improvements thanks to the community and forks of the original projects.