If you're looking for a package manager on Windows, you might be interested in Chocolatey: https://chocolatey.org/
https://github.com/lukesampson/scoop/wiki/Chocolatey-Compari... (scoop) is an option focused on dev tools, http://boxstarter.org for repaving dev/vm machines.
Proprietary https://ninite.com for normally-installed stuff, not sure if the free edition updates things.
How has this limited your experience so far? I'm not really well-versed on even the expected impact this has on commonly used applications... is there any?
In general you will also lose stability and/or performance with complex or intensive applications. For many suites like GIMP, Blender and LibreOffice this is a deal-breaker for me.
And I say that realizing it's only a step removed from downloading an installer and running it, but still.