FYI in a scientific setting, from a microscope to a telescope, CCDs are used where ever image sensitivity is important. (Frequently black and white, 16 bits per pixel, seconds to minutes of exposure time.)
I've been told by machine vision specialists that CMOS focal planes require substantial processing to to correct for nonuniform response between pixels. (I've looked at raw CMOS output from one camera and it looked like a Star Trek starfield from all the bright and dim pixels.) I'd be willing to bet $$$ that all modern DSLRs do some intensive processing on the image even before the "raw" output -- specifically nonuniformity correction and dead pixel replacement.
All this being said, CMOS DSLRs do produce amazing looking images to the human eye. FYI, a decent ~750x500 scientific grade CCD camera starts just below $2000!