In my experience, that's plenty!
Especially so since Sheets has a very advanced API relative to, say, Airtable. For example, you can do atomic updates of multiple sheets in a single request. A single request can contain like 100MB of data. (It'll be very slow, and at this point, a person should question their life choices, but it'll work.)
Is it simply that Sheets can't support a higher rate? At least not the way they currently provision resources across servers?
Since Sheets isn't really designed for high-rate API calls (it's a per-user app, not a database backend), I wouldn't be surprised if it was architected in a way that imposes these limits. Just think of how it's got to add to and consolidate the version history alone each time you modify a Sheet.
It might seem absurd there is no option to pay a bunch of money for “more”, but we also don’t really know what guaranteeing that more work cost. Could be quite a bit of the sheets infrastructure is built expecting those limitations?
We tried it all: options in Cloud Console, speaking with support, talking to sales reps. Google simply doesn't want that money and doesn't care if you are hitting limits and want to upgrade.