What you said is very true, and a good summary of shortcomings, but I'd like to note a real benefit it affords you despite these drawbacks.
While 3. is a pain-point in many systems, the fact that you can do selects with where clauses on a key-value store that scales horizontally is impressive. The indexing they do can be very helpful in certain implementations.