I think results for LR NR depends largely on the camera used, the exposure, and ISO... if you're using cameras that have heavy chroma noise, such as Canon G9 raw, even maxing out chroma noise reduction won't fix all the blue blobs. When it comes to DSLRs, such as the 30D, I find that chroma noise reduction of 25-35 is enough for any shot, and I leave the luminance noise. For underexposed shots and special cases, such as long exposures (or the case of G9 RAW), I will use 3rd party noise reduction...
I have Neatimage Pro Plus, and it yields its best results when profiles are generated using the calibration target and converting with a unique LR preset as the image I want to treat. However, Noiseware Pro's automatic profiling is really quite impressive, and it can yield comparable results to Neatimage's profiled noise reduction.