It's not outrageously expensive if you have hit the limits of of Postgres or MySQL or need multi-region replication, but yes, for small amounts of data there's too much overhead from all the redundancy.
Using it for Vault makes more sense if you are already storing other, larger amounts of data. Then the incremental cost is much smaller and more than worth it.