Update (Aug.2/06): Updated screen capture)
Panoramio brings a great new photo explorer to Google Maps mashup scene. This new interactive photo atlas makes it easy for you to browse the world and contribute your own photos to specific geographic regions.
If you just wish to view the photos that have been posted on this mashup, you can just drag around the map and explore pictures which have been geographically tagged to the map.
Try this site out, there are some breathtaking pictures that have already been posted..