I've run it at home for years and I can't think of any complaints. Tumbleweed is stable enough for daily use, how they do that I don't know. Their testing automation must be amazing. I had to boot from a previous snapshot once in a couple of years. Otherwise, it just works fine. KDE has many complicated configuration options, but you don't have to use them. Most software you want is packaged in the ready repos, if not usually someone's packaged it via OBS and you can easily get it by searching. Gaming is amazing - Steam works fine and just about all games i have run out of the box when the box to use the Proton tool is checked in Steam.
It's good stuff, and like OP mentioned, no snap stores or anything, except it does use systemd.