NoSQL is good if you need flexibility in the data you store. So if you wanted to start collecting user's twitter handles, you could easily add that and then stop collecting them anytime. So some records would have twitter handles and some wouldn't. The table structure wouldn't have to change.
Also, MongoDB in particular has a geospatial data index. So if you were using location data and querying by location (e.g. what's nearby a user's location) that's a great feature. Not sure if other NoSQL solutions have that or if just Mongo.