I batch all of my images that were shot with my 18-70mm and 24-120VR lenses through Optics Pro. I use it to correct for lens distortions, and vignetting, and I think it does a very good job at this. I leave the lens softness correction set at 0, which is the middle setting and does apply selective sharpening apparently proportionate to where the lens is softest (ie more in the corners, less in the middle). I shut off unsharp mask. I leave the noise reduction set on automatic. I leave the WB set at as shot, and I don't do any colour or exposure corrections in DXO as I prefer to do this in ACR.
My workflow is to transfer all of the images off my CF cards, then anything shot with my two midrange zooms gets batched through DXO to produce .dng files. Images shot with other lens (105 macro, 80-400, 300) don't go through DXO). In ACR I rank my images, toss the junk, and do all WB, exposure and colour alterations on an image-by-image basis before moving to Photoshop. Once in PSCS2 I do Capture Sharpening, play more with contrast and colour dependent on the image, creative sharpen selectively, then output sharpen (all sharpening with PhotoKit sharpener).
I usually only use NeatImage on images from lenses that didn't go through DXO, and only when shooting at high ISO.
I like DXO for its optical corrections as I think that it does a very good job at improving images from consumer level zooms. I like the automatic noise reduction as it saves me time and does a pretty good job. When I get a 12-24mm, I will get the DXO module. On the other hand I really don't like the interface of Optics Pro and would never use this program in anything other than batch mode.
I would love it if DXO could be a plug-in to ACR, with a couple extra tabs added into ACR for the lens corrections and noise reduction.