I’m not touching flatpaks or snaps with a ten foot pole, and I have the same experience as you. Switched to EndeavourOS a few years back after having been a Debian (and Synaptic) advocate for almost 10 years.
The AUR is great, and the Arch wiki is a flipping treasure trove. I can hardly imagine going back, certainly not on my work station. Servers will probably be fine running Debian for another few years.