I used to use Ubuntu for everything and was very happy in the massive Ubuntu ecosystem with a .deb for everything till I was forced to use Snap a few releases ago for installing even some basic utils I used on a daily basis. I then had Snap constantly hang on installs and just break for no apparent reason and waste my time debugging it. It didn't "just work" anymore.
Swapped to Arch and haven't looked back yet, Arch took me a lot more work to get set up but once it was it's been pretty invisible, which is how I like my OS to be.
I'd probably happily swap back to Ubuntu if I read somewhere that Snap was removed entirely/canceled or something.
I use OpenSUSE Tumbleweed which is also rolling release, and the one thing that bugs me is that sometimes your tools are so cutting edge that it makes it hard to get older stuff. For example it's super easy to get python 3.10 working in Tumbleweed but super hard to get python 3.6 working.
I needed specifically Python 3.6 to test something, and man that was hard to get working in Tumbleweed. First of all, it is not available in standard repos or pre-built on python's website. Second of all, downloading 3.6 source and building it fails because (apparently) the GCC version I have is too new and creates problems with the `-O3` flag passed during building. So now I have to install an older version of GCC that plays nice with python 3.6 source code...
Eventually I just said "screw it" and used the docker python:3.6 image. Not quite as convenient as having a native python3.6, but "good enough". Not sure what I would do if that image became unavailable.