Agreed. IMO designing disk-first creates constraints that actually hurt on cost/scalability/operational pain in the cloud.

So it's exactly what you said. If you design for 'disk as an optimization', you get very different outputs which are way superior. It's a massive investment though.