I've only meddled with openSUSE a little bit but I suspect it's due to several reasons. Firstly, perhaps the lack of marketing. You hear news about Ubuntu and Fedora and NixOS and stuff, but never really about openSUSE, I think? Maybe they do promotions but I don't know about them that much. As you said, they do a lot of stuff but in the background. Perhaps they're really more of a technical distribution, for sysadmins and some users?
They often tend to sell it as a distribution for developers. for some reason. I don't write much code any more and just use it (tumbleweed) as my main system for general use. I never really noticed it being any different from any other operating system. You just install whatever you need. In my case, I take notes, edit photos, play games from Steam, and do the usual Internet stuff. Mostly what most users do.
I see. Yea, someone I know has used Tumbleweed before and it seems fine. Stable and solid. Just out of curiosity, what Steam games do you play? Do you use Proton?
Currently, I play Deep Rock Galactic, Insurgency Sandstorm, Cyberpunk, sometimes Squad, but I haven't had the time for a while.
Games I have to catch up with Generation Zero, Disco Elysium.