Cmos is actually the winner - the way the conductor is amplified and the way the circuit runs through it allows for significantly reduced electrical interference, producing better image grain among other qualities. It also uses less battery power, has longer life expectancy, etc etc. Its thanks to CMOS that ISO 6400 and 12800 is possible and isn't a pile of s**t.
At this point, there isn't a single current camera out there over $1k that isn't CMOS, including the big 3 - EOS 1Ds Mk III, A900, and D3x. So is the 7D, 5D, 1D, D700, D300, A850, A700. Every single EOS is a CMOS, and has been for years, even the rebels.
But CCD certainly isn't bad, by any stretch. At low ISO I dont think theres any qualitative difference for IQ, if there is, it would have to be an excessive nit pick.