I recommend you check out our OS Support page. CentOS is no longer a supported Operating System, because it is no longer a long lifecycle OS.
For a RHEL-derived, RPM-based distribution comparable to CentOS, you should choose Rocky or Alma, which are supported EL distributions.
You should always choose the OS you are most comfortable with (from among the ones we support). If you have no previous experience, the one that is most widely used and best documented for the applications you plan to run (which will probably be either Ubuntu or one of the EL systems).