An interesting observation that I can't seem to "un-observe" is that Megastore is actually a lot more like MongoDB than one would expect.
Both ostensibly work best when the application fits a hierarchical data model (entity groups vs. documents), and provide out-of-the-box strongly-consistent transactions for a single entity group. MongoDB feels like schemaless Megastore.
Our end users don't have to think much about our storage system, though, if we're doing our jobs right. :)
[1] https://cloud.google.com/datastore/docs/articles/balancing-s... [2] https://cloud.google.com/datastore/docs/concepts/entities