The core checkin functionality is "fun", but not useless, and has a really awesome side effect: Foursquare explore. Seeing where my friends have checked in is a better way to find new restaurants and other businesses than anything else right now. Yelp should be useful for this, but for a variety of reasons, is not.