I don't have much experience with any other programs, but after reading around for a bit, and playing with the Lightroom 3 beta, I chose it, and am very happy with its performance.

I only use it to post process, but I do have an old version of photoshop (7.0) that I mess around with every now & again.