This is a really optimistic take... Realistically your DB of choice will probably try and tackle ACID half-heartedly because it's what devs expect, and that wi

This is a really optimistic take... Realistically your DB of choice will probably try and tackle ACID half-heartedly because it's what devs expect, and that will lull you into the same false sense of security. Many "eventually consistent" DBs will still have some concept that uses the word "transaction" that works like one until it doesn't (see DynamoDB and multi-region gotchas)