Tumbleweed, at least per marketing spiel, is rapidly updated like a rolling release distro,(e.g. Arch) but has good testing and stability like a conventional fixed release distro.
It’s not quite lived up to that fully for me, but I’m pretty sure the times it’s broken have mostly been my fault.
I’ve been able to run it on systems for years on end without them breaking, so it has lived up for me.
One big advantage of openSUSE Tumbleweed compared to other distros (especially rolling release ones) is it’s package manager integrates with BTRFS snapshots so if something does break due to an update, you can roll back to a previous snapshot and still have a usable system and plan what to do next. One of the very few times that things actually broke in Tumbleweed for me (and many other users) I was able to roll back to a snapshot that wasn’t broken, waited a few days, than updated to a release that wasn’t broken.
Also, a more personal reason but I started with openSUSE (11.4 to be specific) back in 2011, so it’s always felt like home whenever I use it.