Comment by mh-

The reason that these "internet scale" solutions are challenging to operate is because of their latency and availability targets.

If you threw into the requirements "can go down nightly, for hours, for writes AND reads", they could absolutely provide the transactional guarantees you're looking for.