I use iPhoto to organize my photos currently, although I am in the process of learning Aperture and may switch soon.
I use Photoshop CS5 (recently upgraded from CS4) to process my photos. I typically do minimal processing, primarily cropping and straightening. Sometimes, a photo also needs sharpening, and to add contrast I use the Auto Tone and Auto Contrast (great new tools in CS5) as well as Levels and Curves.
Favorite Photoshop Tips
Wanna know how to create a high contrast and sharp image using Smart Objectsmake 3-d wallpaper? (curtesy of the Photoshop Roadmap)
This is a sample website produced by Bob Boiko, Elisabeth Robson, and George Humphreys.