I recently removed a couple of blog entries about my disappointment in CentOS Stream, but the About page on my CentOS Stream updates blog tells it pretty well. tl;dr hoping for better things in Stream 9. https://centos.passthejoe.net/about/
I'm running CentOS Stream 9 in a VM, but I'm not eager to use it as a daily system. RHEL-like distros are still hard to use on the desktop, even with EPEL and Copr.
Fedora has everything package-wise, and it has a solid security model and isn't being starved for updates by a parent company. Same is true for Debian, Ubuntu, Suse, Arch, Mint, Pop OS, Elementary, Slackware, etc.
Still hoping for a turnaround in CentOS Stream 9, and that will happen if it's a true upstream to RHEL.
Also, I thought I wouldn't be alone in being bothered by this problem, but I pretty much was (and am).