One of the problems I have always had was how to find great photo locations while having little time to spend in a town or country. A Travel Guide will give you the obvious shots, but limiting myself to those I never found satisfying. The solution I found is to scan the area to which I intend to travel in Google Earth and inspect those little blue markers that indicate uploaded photos in Panoramio. If I find something I like, I note the latitude and longitude and enter those as waypoints (favourites) in my GPS unit.
I quickly learned to zoom in a lot as the larger, more popular blue markers in Google Earth, for some inexplicable reason, always seem to contain the least interesting of photos. My guess is that the larger markers point to the photos Panoramio started off with and therefore have collected a lot of hits over the years especially during the period when few photos were uploaded. By the way, the red markers in Google Earth contain 360° panoramas and are certainly worth clicking through on to scout for locations as well.
To keep the system going, I have uploaded some of my photos to Panoramio which is the site Google uses to allow people to upload geotagged photos to Google Earth. Please have a look at the photos I uploaded.
Update: Sometimes it is quicker to use the Panoramio pages directly and browse to area of interest via their maps. Depending on how far you have zoomed in, most photos will show up in miniature on the map and a panel on the left hand side lists the most popular photos. This way you avoid clicking on all the blue icons in Google Earth and only inspect those photos that catch your eye; all in all, a much faster process.