Interesting. I suppose I also just use very mainstream software as well. I find that basically everything I need is either made for dpkg or exists within Ubuntu repositories (they've got literally everything there, haven't they!).
I agree in your overall assessment though, I can concede to the fact that I might be underselling the value of Arch within the broader Linux community. I've often seen Arch as the detrimental opposite however, which is quite ironic. Personally I just find Debian distros superior to most others (except Linux Mint.I hate Mint, more than anything). I do quite fancy Ubuntu as dekstop, but you truly are right that it is at the very least, not a very good server distro. It might be the worst, imo, Debian server distro.
My go-to choice for a Debian alternative is Fedora, however, so our different experiences might also be a testament to a fundamentally different view on Linux and how you do your computing.