One of the reason, at the place were we ran about 100's of RHEL/CentOS instances, he stayed with RHEL-ish installs was to maintain API compatibility through out the lifecycle of the OS version.
I've now moved on to places were that isn't that specific need. But I still have a few smaller projects that I use RHEL/CentOS/Rocky/etc. because of the stability that those built into the releases.
In Europe it's Debian or SUSE, and in the states it's RHEL. I don't have a preference (but Slackware is awesome).
I was on the forefront of this when they were backporting container tech to their 2.6.32 kernel.
I've also seen them break userspace repeatedly with kernel changes for selinux within a stable kernel.
But as you say, you can pay for support so you have someone to scream at when things go south.
When it comes to ABI stability, I'd trust the vanilla kernels more than RHEL.
Yelling at RH is about as effective as screaming at paint to dry faster in my experience. Their support can be very effective, but it's so slow it's mostly useless. They put you through afew layers of "are you this dumb" before you can get anywhere.