>>3632747>what was the last great ccd camera?The most modern full frame camera with a CCD is probably the Leica M9. Whether or not you consider it to be 'great' depends on your opinion of Leicas.
One nice thing about it, though, is that Leica's next model had a CMOS sensor, so it's possible to compare the two and see if the pinnacle of CCD technology really shows any significant difference in quality to modern CMOS sensors. Spoiler: Not really.
http://www.reddotforum.com/content/2015/03/the-great-debate-ccd-vs-cmos-part-1/ 