I tried Opensuse, I didn't like it. It sort of felt just a bit off and I think a large majority of that was Yast's fault.
Debian and Arch based distros I think will remain my preference for some time given the recent events.
I think I'm with you. I have very smart friends who swear by tumbleweed though. I'm personally using Debian bases for work, and a mix of Arch and NixOS at home.
Don't get too attached. SUSE have their own plans for the future with their whole ALP thing. They say they're going to leave Tumbleweed alone, but we'll have to see how long that lasts.
Then again, ALP could fail miserably and they just go back to the traditional model.
I actually have no real issue with RedHat still, but I moved from Silverblue to Nix just because this whole thing made me consider it again. Nix is amazing. Glad I switched.