I just got "robbed" out of a hour of free time, spent geocoding images for Google, for free. Or, more to the point I was as fascinated with the new(ish) feature for Picasaweb (Las Vegas demo sample)- adding maps and location to images and albums - as I was a while back with the rather similar Flickr feature.
The goggle interface is very nice and easy to use, and with albums already having a "place taken" tag it is easy to start in the right place, and then just drag'n'drop the separate images onto the map.
And since we are talking about 'web2' here, there is obviously an API to go along with it. For a simple sample have a look at "levsplaces" and the related article. The code is simple and builds easily into the established gmaps and other pieces. There is support for searching and using tags, so you could easily create a mash-up 'flying' over the map of London and showing off all 346 dog pictures...
With YouTube also getting the google API treatment, you could take it a step further and add in some top rated videos - since the "balloons" support embedding (used very well by BBC during the flooding in the UK)
Now if I could only find the login info for the gmap test site I set up...