Pictures, With Map and Pushpin Included - New York Times
I think geotagging photos is the next big thing. I have used the Flickr geotagging with the Yahoo! maps for my pictures here: http://www.flickr.com/photos/p_linehan/map/
It works well. I particularly like seeing other pictures people have taken around my photos. I have also tried a tool to geotag pictures in Flickr to appear on Google maps. But I haven't used it much since the Yahoo maps connection became available. Maybe I should try it out more?
I do use Picasa2 to look at pictures on my local drive. Google has established an online catalog for it that also links to Google maps, I think. I can't try everything though.
I really would like to tag photos to Google Earth some time though. Now, that would be great.