No, it's a users choice to use a DB that has this tradeoff. Like it was said a couple of time already, all of your complaints about C* would work just as well

No, it's a users choice to use a DB that has this tradeoff. Like it was said a couple of time already, all of your complaints about C* would work just as well for locking mechanisms in most popular languages.