I've been using OpenSuSE for decades, both for personal and professional purposes.
I can't comment about usability because I've simply used it for so long I know all its quirks and so on. What I will say is the tumbleweed is very stable considering its a rolling release. That's largely due to their automated testing platform. It's got a feel of a work focused distribution like red hat rather than a home OS like Ubuntu. Never the less, I'd recommend it to anyone who asks.
It's not just about crashes. You can switch compositor without logging out or save save the full state of an app to disk to 'sleep' the app if you are short of memory. I'm sure people will think of other possibilities too.