> What Cloudflare is saying out of the box is not only can we do this cheaper, but we'll do it on your behalf automatically
I'm not quite sure this is what Cloudflare is saying. I think they'll be cheaper than the most expensive tier, but I don't think you're going to have the option of (for example) archive storage at a reduced rate. The way I read it is that Cloudflare will have one pricing tier, and they will balance performance internally and invisibly for you.
I'd love to be proved wrong though!