Since you are narrowing down on Tumbleweed, here are my 2¢: After more than 15 years of Kubuntu I installed Tumbleweed a few years (two?) ago, because it offers a rolling release, system snapshots and KDE.
Having a job and a family, I do not have the time to tinker anymore, so I expect things to work smoothly out-of-the-box nowadays.
Tumbleweed let me down in this respect.
Once I had to completely reinstall the system because the snapshots filled the system partition during an update, which made it unable to start KDE. I could roll back from the terminal to the previous snapshot, but couldn’t figure out how to remedy the problem, except for using a greater partition and reinstalling.
And just a few days ago KDE (and many applications, when used in LXDE) wouldn’t start, because of version mismatches (caused by an incomplete update?) that broke the linkage of qt libraries. To resolve it I had to make a decision between two packages (tlp vs tuned) to finish the update, even though I hadn’t installed those manually and didn’t know anything about them.
Besides those problems I find the administration suboptimal, with the divide between the Interfaces of Yast and the KDE settings. I didn’t manage to get my Brother network printer to work (except via direct USB connection), which worked out of the box with my android phone.
What’s so great about Tumbleweed’s KDE? Honestly asking, because I am using it, but don’t see a ton of a difference as compared to Kubuntu. Not that I am actively looking for differences.