These distributed data stores are so appealing from the perspective of uptime and stability.
Needing to upgrade the DB or take cold backups or run massive schema migrations is the reason for lots of scheduled downtime.
And removing the huge whopping single point of failure from your system that you would have with a traditional RDBMS can only do good things for your stability.
Example: http://googleappengine.blogspot.com/2011/07/java-app-engine-...
Sure, it is a small point, but it actually matters a lot. At this point everyone hosting a real service that cares about uptime should be on HR.
I had someone from google tell me that GAE lost an entire datacenter and nobody noticed.
Also, there are lots of instances of localized downtime that doesn't make it into the global system status - you only have to hang out in the IRC room to see people coming in with "is anyone else seeing really slow startup times" or "is anyone else not seeing logs updating for the last hour".