I was on Ubuntu for a year. No major issues, although I used the interim releases, which are supposed to be less solid than LTS. Then, a couple of months ago, I decided to switch to Fedora, just out of curiosity. Many people stated how Fedora is rock solid, Fedora is the new Ubuntu, etc. First some rpmfussion updates broke mesa, then the ostree update broke Flatpak, and recently there was a broken kernel 6.3.11 update that affected some AMD users. A few days ago, I updated my kernel to 6.3.12, and I got frequent freezes on boot. Other users are also reporting such issues. So now I boot with an older kernel. Which is not optimal. There is no LTS kernel on Fedora, the old kernel version doesn’t receive security updates. Was it always like that, or it’s an unusual bad phase.
I think it’s worth noting that Tumbleweed also has the Mesa/codecs situation, where if you want the codecs you have to enable the Packman repo and install mesa from there, and when there’s an update for mesa you have to wait for the update on Packman repo, otherwise you get some conflicts when trying to update. Though packman usually updates quick enough so it’s usually not an issue but it can be a bit weird the first time you see it.
Aside from that yeah, Tumbleweed is great. Though i’m currently running Fedora Kinoite and overall I’ve been happy with it, but I would probably go back to Tumbleweed if something were to happen.