Isn’t CentOS Stream equivalent to Ubuntu LTS in terms of stability? They both tend to use packages that have been somewhat tested alas not to the point of Debian/RHEL
Opensure Tumbleweed is more like Fedora Rawhide, they get the absolute bleeding Edge. CentOS stream is downstream of Fedora, so you get less newer packages