CCD cameras work better at night than CMOS. If you get a camera that has OSD (buttons and settings menu), you can adjust things like make it more sensitive for night flight, or make it where looking at sun you can still see ground, or fix bad colors that happen when there is no white in picture. Also automatic SenseUp can get even more light sensitivity by reducing frame rate.
A good CCD camera plus a good light gathering lens will make it possible to fly with just moonlight. My best camera sees better in the moonlight than I do, I don't have trouble walking around in the moonlight.
CMOS can definitely be smaller, lighter, less expensive.