The important thing to consider is: What tradeoffs are required to achieve consistency for your use case? Delivering consistency in either the CAP or ACID sens

The important thing to consider is: What tradeoffs are required to achieve consistency for your use case? Delivering consistency in either the CAP or ACID sense requires some amount of constraints on other aspects of the system. Sometimes making this tradeoff it worth it, sometimes it isn't. The key is to make the value analysis for each problem you face so you can determine the best overall solution to the problem at hand.