Localscope (US $2.99) has been around the app store for quite awhile, and continues to get updates that make the app a great way to explore your surroundings without moving an inch. This latest update tweaks the GUI and adds geo-tagged video resources from YouTube.
While some discovery apps give you loads of text, Localscope provides geo-tagged media files to show your picture, maps and videos, and then provides direction pointers to destinations. When you are ready to leave, you can navigate by direct linking to almost every navigation app available, including, of course, Apple and Google Maps, TomTom, Garmin, Navigon, Waze and dozens of others.
The app integrates info from Google, Facebook, Foursquare, Twitter, YouTube, Instagram, Yelp, Citysearch and many more. It works anywhere in the world, and has built-in support for 21 languages.
You can search by category (museums, restaurants, locksmiths, etc.) or you can type in any business name or destination.