> I'm curious if there exists something intelligent enough to be able to rely on it for a large-scale deployment without human oversight?

I think without a context that's a no. Some systems will want good throughput, some want low latency and require pre-scaling on some cues (time of day, day of week), some want minimal cost but do want to allow bigger bursts for a max of N minutes, etc.

Any intelligent scaling without human oversight has a good chance of either burning your money or not optimising for what you care about.