CentOS is deployed in my organization in both on-premises and private cloud environments.
The cloud provider we primarily use for our private cloud deployment is AWS, and we also have a private server that is essentially a blade server where we have deployed it.
I have not dived into the security features of CentOS that much, so I am not sure I am a good person to answer that question.
I have pushed CentOS to the limit by testing an application where I had to accommodate multiple users; I increased the port number to allow 10,000 users to connect to that application hosted on a CentOS server.
CentOS handled that situation reliably; while there were some difficulties changing some settings inside the application, once I managed to tweak the settings, it worked very well, allowing around 10,000 users to connect and chat simultaneously.
The only compatibility issue I have faced with CentOS is with the biometric drivers, such as the fingerprint drivers, which were quite complicated, but generally, whatever I am trying to run works quite well.
My advice for others looking into using CentOS is that it is quite sane; there is not any bloatware on it, and everything just seems to work. I would rate my overall experience with CentOS an 8.