Personally I find the ops pricing makes sense. It’s easy to get an idea of how expensive a query is by looking at the info in the shell of the dashboard.
After a while it becomes more intuitive and you plan ahead with efficiency in mind.
Cloudflare already has a distributed KV database and I’m certain it will release a more complete distributed DB offering, probably this year.
As much as I love Cloudflare, I’m skeptical it will have as many features as Fauna. I could be wrong but I doubt they will have a query language or authorization layer as powerful.
One problem I’ve experienced with Workers KV is that unless you have tons of traffic most of your requests will not come from the edge. They have so many PoPs (points of service) around the world that 2 users that are somewhat close geographically (eg: Paris and London) will not use the same PoP. I think this is solved using their Argo router which can fetch data from a nearby edge location instead of going to the origin (or central location for KV) but then requests become much more expensive.