[bojan]

CCD techology was always better performer than CMOS in terms of sensor noise, and it was purely process problem, there were no fundamental theoretical problems that would favour CCD over CMOS.
Canon (and Foveon, I think) sensors changed that, so today both tehnologies give similar results.

However, the definite advantage of CMOS over CCD is power consumption: CCD requires relatively high voltages to operate, and CMOS does not. Also, CMOS allows direct addressing of any pixel in the array, and CCD does not (architectural reasons).
Also, CMOS process is used for digital circuit manufacturing, while CCD uses totally different process so it is not possible to mix digital circuitry on the same chip with CCD, one of things that bring the manufacturing costs down.
That is why affordable commercial cameras are much more likely to use CMOS sensors. If someone still uses CCD (in mass production) there must be a trade-off somewhere to offset the manufacturing cost.

While CCD is still better in terms of noise (one of the reasons is, there is no digital circuitry on the same chip so readout noise is easier to suppress), it is much more expensive to manufacture the cameras using it.