Whilst I don't at all doubt your testimonies, I am still sitting here wondering what programs everyone here is using, if not programs usually tailored for Debian. I feel like I've seen more software that runs natively on Debian (Ubuntu, really) and made specifically for dpkg.
But I suppose a lot of applications also come with "snap" these days, but I avoid "software stores" like the plague.
I personally have had very little contact with Arch, but I realise that is me that is strange, I personally dislike Arch very much and can recognise that, that might be the reason I don't see it around as much; a negative confirmation bias of sorts, if you will.
99% of the time when I have an issue and I just google it, I'll end up on the Ubuntu forum, that's no lie. But I do seem to remember using the Arch wiki years ago. I'll admit, I'm probably just a diehard fan of Debian.