I’ve used Tumbleweed in the past, I use Aeon (OpenSUSE MicroOS) now, and I was a longtime Arch user before this. I will take Arch over Tumbleweed every time. The repositories, AUR and docs are just better. OpenSUSE’s OpenQA and OBS are cool, but, in my opinion, don’t offer enough value over Arch. There’s also YaST, which I don’t care for, but YMMV.
With Aeon, the repositories aren’t really an issue because it’s a different workflow with distrobox. I just pull in Arch packages if I need to. The docs still leave something to be desired, but I’ve been using Linux since the late 90’s so I’m pretty comfortable. I really like transactional updates and immutability on Aeon.
I wouldn’t call it a mess. There’s a reason it’s not standard. It’s because Linux is about having choices. Linux users have such a variety of use cases and there are a zillion different kinds of hardware it runs on. There’s no one thing that works for everyone.
I think this flexibility is a big part of what makes Linux special but also what makes it difficult for newcomers. The documentation on all the various software is typically very good to excellent. The harder part is figuring out which choice to make in the first place.
I don’t really have any answers except to take it all in and be more willing to do some research than some other platforms may require.
System-wide DoH is sort of a power user thing to begin with so other platforms will likely be similar. I think you would probably be using some kind of app to do it on Windows or Mac.
By the way, you might want to take a look at stubby for your situation. I did something similar a few weeks back and that’s what I used. It’s runs a little local DNS proxy that forwards requests to your upstream servers. Then you would set your DNS server to 127.0.0.1 in NetworkManager or whatever you’re using. You have to change like 3 lines in the default stubby config a typical distro may provide to make it work.