You're right in that there's a few services that expose this complexity directly, the ones where you're paying for actual storage, but this is just complex, not impossible.

For one thing, storage costs are almost always static for the period, they don't scale to infinite in the same way.