This really resonates with our observations.
I think it's a "business" problem first (pricing) indeed and a technical one (once you've decided on pricing).
Your insights are why're very bullish on "hybrid" pricings: usage subscriptions, fixed costs that can be overaged but with prepaid packages or prepaid credits. In that case, the end-user still gets the "we pay what we use", while there's predictability/peace of mind on the final bill (you can't exceed what you prepaid).