HooRU .deb packages for non repo apps is more ubiquitous with Debian Branch stuff,
That's actually a bad thing, if you stop to think about it. Users are trained to add a PPA & install it without putting thought to what they're installing & whether they can trust the source. I'm not saying the AUR is inherently more trustworthy, but it does put that kind of thing all in the same place which seems to discourage the possibility of a bad actor, and because it's not precompiled libraries or software versions it makes independent review a lot easier and makes library conflict nearly impossible. I really can't fault Ubuntu for trying to push snap as a solution to everything, because it does largely solve the PPA problem, but I can definitely hold the fact that they're still pushing snap after flatpak clearly won against them.
As far as Arch goes, I have literally never had to download a precompiled package from somewhere. Just doesn't happen. 99% of everything I want to run is either in the mainline repository or has the official distribution as a flatpak. And for everything else, there's the AUR. AUR isn't generally enabled out of the box, but yay (the AUR package manager) is a handful of commands away from installing on a new system, and then it works pretty much exactly the same as pacman but with a bigger repo. I cannot remember the last time I wanted to install something that wasn't in one of the main repos, flathub, or the AUR: I don't think it's ever happened since I switched to Arch.