> You can get a single box with hundreds of logical cores and many hundreds of TiB of locally attached ssd

And then that box falls over because the entire region fails like just happened yesterday with OVH. Or it just randomly fails like has happened to me with AWS dozens of times.

Vertically scaling a database on your own cloud instances is amateur hour. Either use a cloud-managed database or one that is highly available.