i use a combo of things, photoshop cs3 for batch action stuff, imagineomics noiseware for my noise reduction, run as part of an action in cs3, i have written a large amount of actions for cs3, they all have anywhere from 1-5 steps, depending on what the photo is of, time of day, lighting etc
ie: if it's a night outside wdw photo without any neon, i have an action that has imagineomics night, kelby lab color correction with 15% pin light overlay, then kelby lab sharpening, i open 1 photo up, see how it looks with the action, if it's what i want, i then close without saving changes and run the action on the whole folder
i do all my basic processing in lightroom, then export like photos in folders as psd files, do my batch actions,put my brush stamp signature on them, reimport back to lightroom, where i then make the final decision on which ones go to my phanfare site, i have an export preset in lightroom to directly set up albums and sections and export as jpegs, sharpened for the screen
imagineomics runs as a ps plug-in