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". 🙂
--Jeff Moden
Change is inevitable... Change for the better is not.