I've got 256GB and a fresh install of windows use about 4 with a few things running on startup(mostly just the amd+nvidia drivers). There is indeed some scaling with availability but with diminishing returns after probably 8/16gb of available ram.
What I find more interesting is that windows still compresses and swaps on startup even with that much ram available.
Disable swap (pagefile) when you have that much ram, or even when you only have 8 or more. You lose hibernate but that's fine by me. Modern cpu and ssd cold boots pretty fast, especially if you have debloated things similar to this script.
Many of the things that are pitched as beneficial, like indexing everything and caching the indexes and keeping all kinds of services alive to "quick start" other things in case you happen to want them, hibernation or sleeping instead of cold boot, etc, these are all cases of adding more crap to counter the harm from previously adding other crap.
Instead of adding foofeature you don't really need, and then adding foofeatureaccelerator to try to disguise the overhead of foofeature, you can just remove both foofeature AND foofeatureaccelerator, and everything is better.
Less total software to break or misbehave or serve as a security opening. Smaller disk footprint. Fewer running processes. Less ram/disk/net resources consumed. Less telemetry. Simpler total system for you to manage, and maybe actually have a hope in hell of grasping more of what all is going on with one human head. More of your resources available for the apps and services YOU actually want, whatever they are.
Whoever wants Pandora, they can totally have it without it coming pre-bundled. If I want Pandora, I would rather install it than find it already built in. In fact, I DO want Pandora, but in fact, I use a 3rd party open source unofficial player. So even though I use it, it's still wrong for it to be built in.
What I find more interesting is that windows still compresses and swaps on startup even with that much ram available.