Fedora's more playground / cutting edge technology demonstrator for Redhat developers. Anything showing up in Fedora won't be included in RHEL for several years, assuming everything goes well.
CENTOS Stream slots in between Fedora and RHEL, keeping a bit ahead of the RHEL stable release.
I'm pretty much on the complete opposite end of the Linux ecosystem, working primarily on embedded systems.