Sounds like you want a PhotoOpWiki. It would need to be a humungous database to cover all the possible genres and styles of photography. There is
The Photographer’s Ephemeris, but that’s designed more for determining sun angles for lighting than it is a “Where and what to shoot” app.
I have the most success just Googling the place and using a few choice keywords depending on the type of photography I’m interested in. A friend of mine makes use of the photos that appear on Google Maps or Google Earth to get a sense of “what’s there”.
I’ve explored the possibility of creating a photo location guide and began a website for
nature and landscape photography in southern Ontario, but quickly discovered how monumental the task can balloon into. Maybe this is a job for retirement! Learn some php and make it a proper database-driven site.
I’ve also mostly completed a
Google Map of Iceland with geotagged photos to give people who may be planning a trip what’s where.
Anyway, this doesn’t really answer your question except to say I’m as curious as you are to learn what people have found in this regard.