I was considering this, but in a survey most respondents preferred a prepaid model to avoid surprise charges. The flatrate model does that too, though. Maybe worth trying in the future. Like Spotify for open source apps.
Something that could potentially be a big improvement (in actual efficiency, not just pricing) for low-traffic apps, would be to allow users to provision a set of resources that are shared between multiple apps.
I think combination of two would be the best. In this case I can have a beefy nextcloud pod, and then some shared pod that hosts multiple less demanding apps.