Where's the option for those of us using both? I'm a huge proponent of choosing the right tool for the job. There are applications where a relational database, like MySQL or PostgreSQL, makes more sense than a NoSQL implementation. And in those cases, you can either go out of your way to make a NoSQL solution work, or you can just use the better tool for the task at hand.
Too often I think people go down these "__ is awful, don't use it" roads, and do so to their own detriment. To not use a SQL database just because people rant and rave about NoSQL is foolish.