Then that would be an astro CCD.
For bog standard, sounds like the Canon 6D is a favourite at the moment, along with the latest Sony mirrorless cameras.
My problem is my budget is pretty low so I usually have to wait a couple of years to pick up something second hand. By then something better is out.