The visible color usually is not the silicon sensor itself. A bare CCD or CMOS chip tends to look gray or slightly iridescent, like other silicon devices. The color you see is mostly caused by layers in front of the sensor: the color filter array (often a Bayer pattern with twice as many green filters as red or blue), plus other filters/coatings such as IR/UV and low-pass filters. These layers can make a sensor look greenish, pink, blue, etc.

Coatings can also show thin-film interference, which changes the reflected color depending on layer thickness and viewing angle. That’s why sensors in photos can look different even when they are similar types.

So CMOS versus CCD does not inherently determine whether a sensor looks green or pink. A 3CCD camcorder would also get its apparent colors from the optical/filter arrangement rather than from “CCD” alone.

Yes, the light source can affect the apparent color, because you are seeing reflected light from the filter stack and coatings. Sunlight and a white flashlight may make it look somewhat different, especially with different angles and spectra.