NoSQL types of databases may, in fact, be the answer. Now, lets figure out what the question is. 😛

If you need a database that is essentially nothing but a place to store and retrieve data to and from, like some lightweight desktop application or perhaps a smart phone application or simple inventory for a refrigerator application (yeah, they're here), the NoSQL database types may, in fact, be the way to go.

Change your requirements to something that has to support thousands of users on a system that has mega-row reference tables and giga-row main storage tables and, you're correct, NoSQL probably isn't going to hack it.

Like everything else in our business, "It Depends". 🙂