I wrote a rather long comment on digital-photography-school.com about the photo processing software that I use.
I start with Breezebrowser, which I use to relabel all my images and videos to a common format. Some of the images get label sequentially and separated into another folder, which is very easily done by Breezebrowser.
Then I select my favourite photos by giving them star ratings using Adobe bridge.
I currently use Adobe Photoshop CS2 and ACR to process the raw images, though I will probably upgrade to CS3 sometime soon.
Within CS2, I reduce noise with NoiseNinja and correct for lens/vertical distortion using PTLens. There are then minor adjustments to curves and any touching-up or removal of blemishes.
I also have Lightbox, but haven’t used it much. It might be more useful when I upgrade to CS3. I would like to use it for adding IPTC info to photos in batches.
I may move to using Bibble Pro for raw conversions, as it builds in the NoiseNinja.
Though I have RoboGeo and always use a GPS to take tracks of my locations, I don’t use RoboGeo to add location info to my photos. I would ideally use a program (not yet written, to my knowledge) that automatically suggested IPTC and description info based on an Internet database of well-labelled photos in the vicinity. Maybe Google could be persuaded to take on such a project.