CCD is usually preferred, although CMOS technology has improved and is also useful. I think that most CCD's have lower noise and are better for long exposures. But if your imaging bright objects such as planets, CMOS can do fine. CMOS are often cheaper in cost. Some cameras such as the Meade Lunar Planetary Imager use a CMOS sensor. It's very camera-specific, and depends on which sensor is being used in the camera. Some are much better than others. I can't comment on those cameras that you mentioned.
If you want to make an informed choice you need to look at the specifications for the camera, especially the low light sensitivity. Usually this is indicated in units of Lux. But there are many other factors to consider as well, such as the software, the lenses, the cost.
Different types of cameras are useful for different imaging techniques. What is it you want to image, and whats your budget?