Recently my old Canon ZR-60 Camcorder died. It was used mainly as an analog to dv converter and portable recorder. Most of its life was spent capturing underwater ROV (Remotely Operated Vehicle) footage. I took the camera apart mainly to figure out how to get my dv tape back that was stuck in the tape drive. I took apart the imager module and put the Zr-60's CCD under my microscope. At the highest magnification you can jut barely make out the individual photosites. HowStuffWorks has an interesting article about CCD imagers.

Canon ZR-60 Imager