The CosmosDB serverless pricing model seems very good value for small to medium usage. CosmosDB is also unique in it has geospatial type/query support which DynamoDB etc don't. I believe the serverless pricing is fairly recent so not sure if you checked the pricing before it was released, also on the pricing page you need to specifically click the "Serverless" tab which isn't to obvious as a clickable tab in the UI.
I've recently tested it as needed geospartial query support for a hobby project and the cost is cents per month with the serverless pricing model. I'm also accessing CosmosDB outside of Azure to use low cost VPS hosting and latency is pretty acceptable for web type stuff.
If you are DB read/write heavy obviously pricing is going to be higher due to pay for what you use, pre-provisioned pricing will become the better value option at that point.