I was wondering if there is a website where people can share the best spots to take pictures from (of course, this would mostly apply for outdoor photography). Essentially, a map with dots indicating the best spots, reviews and the like.
At least according to Wikipedia, these types of sites can be referred to as geolocation-oriented photo sharing sites.
Here is the list of what I use:
This next one gets it's own category, because it simply is indispensable for Landscape photography especially, and really any location scouting:
Also I know that I did not directly answer your question. It is hard for tool to answer the "best photography locations" question - because clearly for each individual the experience can be different. I wouldn't trust some "Yelp" or "TripAdvisor" like review site for locations, I want to see the photos! So to me the above fulfills that need. You can use the different tools to drill down into certain keywords or popular photos in an area, and simply find something that appeals to your eye, and not the text from someone elses reviews! Further - You are probably better off using something like TripAdvisor to just find global destinations to travel to, then use the above to find the actual photo locations that interest you.