As a heavy Yelp user, I've found it helpful for places that don't have Yelp, like Asia. While not as reliable, I still find it very useful to see what the popular and highly rated places are.

I use it primarily for top "must-see" attractions and restaurants. The community-based travel guides/lists are also helpful.

Hotels are good for making sure you're not getting a good deal on a slum.