Transparency is one more arrow in the quiver of the NoSQL camp. Throwing a SQL query at a black box and hoping that it figures out the most efficient way to execute that query is a scary way to access your data in a real-time application, especially when the query plan can change drastically based on what data is in the database.
I hope to never have to sleep with my hand on my phone waiting for Nagios text messages again. I'll take consistent data access performance characteristics, thank you very much.