I think i'm gonna come off sounding like an advert, but oh well.
For the last year or so i've been trying to find some decent, free or cheap, software to tag my photos. I've tried dozens of progammes: Picasa (good software, terrible tagging), F-spot (great if linux is your main OS), picajet (better than picasa for tagging, but still not right), plus dozens of others that always get suggested. They are all ok for drag and drop tagging, but once you have over a screen of tags that becomes a nightmare.
Eventually i shelled out a fortune for lightroom, which was pretty awesome, but still not perfect (and kinda sluggish on my pc).
Anyway, to cut a long story short, a few days back I discovered Windows Live Photo Gallery and its great. TBH I've always avoided Microsoft, but this is free, pretty lightweight, fast, has autocomplete tagging, and has a really cool import feaure that splits photos into logical groups.
Its still in beta, so its missing the odd feature (photo straightening) but if you take a lot of pics and are into tagging i recommend checking it out. (PS/ it has a cool, autostitch style panorama maker).
You can get it from Microsoft at:
http://get.live.com/photogallery/overview
Also, it has an API to allow services to be added. I have no idea what that would take, they currently only have Live Picture gallery and Flickr supported, but if 23 could use the API to add the service it'd be a great way to (a) allow users to upload easily, and (b) promote the site.