You don't already do this for Linux? :( A new Linux setup already requires me to visit a bunch of sites and find .debs. Chrome, Signal, Edge, Visual Studio Code, Slack, etc. I don't really trust random unofficial maintainers in snap store and all of the above is required for my work.
It isn't impossible to have both. An app store that is a registry pointing to packages/files hosted by the developer. And since you mentioned Windows, that's exactly how choco and winget work.