Red Hat says they do a lot of testing before anything goes into CentOS Stream. That's what I meant by pre-release testing. Since the changes are intended for RHEL they're already carefully reviewing and cherry-picking everything from upstream anyway. This is a lot different from for example Debian where you have volunteers merging random snapshots from upstream into unstable, and then if that doesn't crash unstable for a week or so it's automatically moved to testing.

CentOS Stream is not for everyone and I don't know what OP's criteria are, but since they're considering Debian and Fedora and are willing to pay for RHEL then their criteria probably allows for CentOS Stream. Alma and Rocky seem okay if you're willing to trust relatively new distros, and Oracle Linux seems okay if you're willing to trust Oracle. They're all valid options depending on your needs.