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.