You guys are obsessed with storage space
A 500 GB HDD costs ~25$.
Whether a pruned nodes needs 2 or 20 GB is pretty much irrelevant (IMO).
If someone is doing 2 requests per second, thats more than 7k requuests per hour. I would guess that he should be able to run a full node and give up on 2-20 GB on storage space in this case.
I only mentioned chainstate size for clarification sake. If i were obsessed with storage space, i wouldn't run full node or complain to Bitcoin Core dev for not using best compression algorithm
But i agree with you, with pruned node, there's serious limitation of self-hosted API features that you could use.
IMO even though the low end VPS use SSD, the RAM capacity usually is low and it has to be shared VPS which hinder request could be handled by Bitcoin Core.