In addition to the asset management tools others have mentioned, it's worth noting that the different applications are often geared towards different goals, even in terms of rendering.
If your goal is colorimetric accuracy, I don't think you're going to beat Raw Photo Processor, especially if you know how to create ICC profiles. It's also probably the best at emulating various film stocks, though that's not something I do.
DPP probably produces the best image quality in terms of sharpness and noise reduction and lens defect correction and the like, but I've never cared for the user interface. If you're the type to drop your photos off at a lab, DPP is the best for you.
Camera Raw / Lightroom offers the best flexibility for creative manipulation, no question. When I'm looking to do that sort of thing, I generally develop the file with Raw Photo Processor and then open the TIFF in ACR for further manipulation.
Lately, though, I've been more and more paying attention to the light itself and doing less and less work that needs much post-processing. The attached photo, for example, is nothing more than two colorimetric developments of the same RAW file, with the one for the sky slightly underexposed and masked in to restore the detail. Shoot in great light (whether by painstakingly finding it or making it) and develop the photo such that what comes out of the camera is the same as what went into it and you won't have to do much, if anything, to it in post-production.