Ayyappa J, thanks for the follow up.
You are correct, all depends on your X. If, for 1 million of call, X is higher than, roughly, 4, Cloud Endpoint is a good choice.
Consider that a query to your service trigger a BigQuery query that scans 100Mb of data. 1 Million of them cost $500. If you save the half, you save $250. Your addition $3 for Cloud Endpoint are quickly saved!
You can also imagine that your API return the top ten of document stored in Firestore. If you read 10 millions of document (top 10 over 1 millions of request), your cost is already at $6. Cloud Endpoint is also interesting in this case.
You can also see Cloud Endpoint as an API gateway. You expose only one service and you can route the paths where you want. This is a great advantage to hide the deployment complexity to the users.
It’s not the tool to use every time, but when the use case require it, it’s a powerful ally!