Still not sure whether I want to move to Tumbleweed or Gentoo. I have reservations that Gentoo might be less stable but on the other hand you don't have to `emerge --deep @world` every day.
Arch Linux is your friend. You will find all the packages in AUR and answers you seek in documentation or with extremely active community.
Not as ‘deep’ as gentoo and not as script kiddy as tumbleweed. I use Leap for servers and installed gentoo to learn things initially. Love all the distributions named here!
They exist as collection of scripts to install precompiled (or to be compiled) packages, maintained by 3rd party developers as means of convenience, they’re not to be blindly installed as system packages (which I agree is what often people would do)
It offers certain autonomy to users on top of stable system to build/preinstall packages when they deem it necessary.
It’s always advised to check what’s happening with AUR scripts & updates, in archwiki with well noted warnings.
These things don’t sit well with script kiddie style of doing things!
It also makes it easy to write and share your own packages when you need something that's not in the repos (or the AUR). The first package will take you about an hour of reading documentation (which is 10+ times less than it took to build my first Debian package), but the next ones will not take more than 5-10 minutes.