Stream is only "between" fedora and RedHat until RHEL X.0 is released.
For instance, once RHEL 9.0 development branched from fedora 34, Stream 9 became the upstream and just ahead of all further RHEL 9.X releases, and doesn't depend on fedora anymore.
Furthermore all Stream rpms undergo the exact same RHEL testing and quality validation chain than proper RHEL packages.
As such by using Stream 9, you are arguably receiving the bug fixes that are eventually going into RHEL 9 proper, just in advance a bit.
RedHat engineers have argued that keeping up to date would amount to effectively running a faster fixed (less buggy overall) OS than RHEL.