NoSQL is giving up FAR more than ACID. It is giving up the ability to consume the stored data in a beautifully concise and expressive manner.
edit: 'the ability to'
edit: 'the ability to'
For a lot applications/use cases, schema free get/put/delete is a lot more concise than any SQL concoctions. Besides, using RDBMS/SQL to store/retrieve complex graph is neither beautiful or concise.
Just because you can use your Swiss army knife to kill a few roaches doesn't mean you should.
Say I have a domain model that involves a primary object e.g. User with lots of maps and arrays then how is SQL going to be better then ? Lots of tables and joins better than a single document. I think not.