A curated application repository where things "just work"? Yup, that's Debian. Oh. Wait. Maybe that's just me. For the past 15+ years.
The "app stores" have some curation mechanism where apps are tested to ensure they work with the system as a whole, right? So does Debian. Debian's isn't fully automated, I admit, but Debian has managed to face various issues head-on like multiple BLAS and LAPACK libraries (quite important to me), a variety of network configurations, etc.
I'm touting Debian just because I use it. Fedora may well be similar. I know RHEL is *NOT*. It's a royal PITA to figure out how to install many things that just work under Debian. (Ubuntu is dead to me for situations that occurred long ago.)
Debian's problem perhaps is leaving too many choices to the end user. But an "enterprise" Debian could pre-choose (well, pre-seed, etc. for FAI) by providing a single deb. When I had more machines than I needed at home, that's how I ran it. Want to pin a version? The package dependency mechanisms handle that quite well. If that prevents some new package or version from installing, you have a clear error message to send to your support folks.
I just don't get what's so hard about all this. Other than there isn't a single company to blame for all the decisions with which you disagree but that you'll slavishly follow.