Back to the origin of the post, I get the past year a 2006 Pentax K10, 10 MP CCD.
Just cleaned the sensor, get the way to adjust focus in the service menu, and set other old reliable, a 35 mm F2, auto focus but designed for film.
Used it in a trip among modern 24 MP CMOS cameras. And I like what i get from it.
Even in 2016 the images were accepted here.
The images from the modern sensors are better for work in PS. But the old sensor ones had rich and nice colors straight from the converted raw. And, more important for me, I really enjoy the experience.
Back in 2008 when I started here I used a camera with the same sensor. Now I know that it is still suitable for produce quality images for current standards.