When I shoot RAW, which is almost every time that I am shooting for a special reason or someone, I think the greatest editing tool(s) are Adobe Camera Raw from Bridge, and then importing to PS Cs2 (cs3) to do the "real editing".
When I shoot .Jpg, I'll go straight to PS Cs2 or Cs3 depending on location.
Through bridge, I download my photo's, batch rename them, and organize them for future editing ease.
I don't think I will ever use any program other than Adobe's Photoshop line. I've just gotten so attached to everything that it has to offer etc'. It truly is a wonderful program. Almost anything that you can imagine, you can achieve in Photoshop. It just takes time, patience, and practice.
I tried Lightroom out for a little bit, and it was alright and all; but again, the level that Photoshop is on is completely different than what Lightroom is on.
I think it is worth learning (if you haven't already of course) the ropes on Photoshop. You'd be amazed at the things you can do.
But in general, my average post-processing includes the following:
-Remove facial blemishes when doing portraits.
-Adjust lighting, colors, saturation of skin (portraits), sharpness/softness.
-Photo-manipulation (ex. "photo plastic surgery" - portraits.)
*Photo special effects - B&W, Sepia, or any other duotone.
The list really goes on
Anyways, that's just my little thought.
Best,
-AC