CentOS stream is red hat.

Oracle also was the first to release updates last time I compared the three of them side by side, which was about a year ago. I installed Rocky, Alma and Oracle 9 on three VMs, pointed them as close to upstream repositories as possible (to avoid mirroring delays), and just started them every day to see who was the first to update. I also checked RPM metadata which includes build time. The experiment ran for (IIRC) about two months.

Oracle was consistently the first, lagging behind RHEL for a few hours (for important stuff) to a couple of days (for less important ones). Alma was a very close second. Rocky would spend days to weeks and was by far the slowest.

No, I don't buy the argument that it's good for you because they receive additional testing. If you really need that much stability that you can't take an update after RHEL has done so, introduce your own delays and test your shit on staging. I'd like my upstream to be as quick as practically possible. Oracle and Alma cover that nicely.

All this might have changed in the meantime.

Alma is based on centos stream. Centos stream is red hat.