Get Lat Lon
Get Lat Lon is what I am currently using to geo-tag my photos.
I do a search then copy/paste the latitude and longitude into my photo database.
It then geotags my photos on Flickr with the location.
The next step is to incorporate the map lookup functionality into my application directly to save me the copy/paste step.