Personally, I don't think that NoSQL is a fad.
It's simply a tool that solves a specific set of problems.
The real trick to them is recognizing when you're actually facing a problem that they solve. Sometimes, as developers, we get caught up in the excitement of a new technology, and as the saying goes... When you have a hammer, everything looks like a nail :)