Well, I use Lightroom as my "workflow manager" and so do my Raw processing there.
And, the Lightroom Raw processor, shared with the Photoshop Camera Raw processor, has a significantly more advanced toolset for Raw than DPP.
That being said, DPP is quite nice for Raw processing when you don't want the advanced Lightroom capabilities. It's great for quick in-out conversions. Plus, it has tools that replicate the in-camera tools for creating a jpeg -- the basics of Picture Styles and White Balance, plus enhancement tools that get added to DPP when new image enhancement functions are added to new Canon cameras -- pretty cool when those features can be made available to photos taken with older cameras.
For those reasons I'm not dismissive of DPP! In fact, on any given day I'll often have DPP open right alongside Lightroom, sometimes "messing" with something, sometimes doing a quick conversion for whatever reason.
But, DPP and Lightroom don't "share" Raw processing/metadata, so work done in DPP won't show up with a Raw file in Lightroom and vice-versa. So, since Lightroom is my Workflow manager as well as my "serious" Raw processor, in the end shoots that have "meaning" to me go through my Lightroom Raw processor.
As to which Noise Reduction handles detail better, well again LR has more advanced tools, and, when I'm dealing with high ISO images with noticeable noise I'll be in Lightroom automatically, but if I am in DPP sure I'll toss in NR if it's appropriate to get a working image out the door.