Cameras are sold separately.
Fork mounted SCTs like the CPC run in alt-az mode (up/down left/right movements). Although the controlling software can track objects fine for visual use, because neither axis points at the celestial pole, tracking alt-az mounts suffer from an effect called field rotation.
Think of watching a point on the rim of a wheel as it rotates - you can track the point, but the direction to the centre of the wheel changes as it rotates. in images, that means that the field of view appears to gradually rotate around the object you're tracking, which causes trailing that increases as you move away from the object.
This limits your maximum exposure time before the traiing becomes noticeable. Exactly how long varies with your latitude and where in the sky you're pointing, but around 30 seconds or so is a rough ballpark figure.
For longer exposures, you either need a field derotator (Meade used to do one, but as far as I know Celestron never have), or (more commonly) an equatorial mount. With one axis pointed at the celestial pole, tracking an object doesn't cause field rotation from the point of view of an attached camera - for the wheel example, think of a camera attached to an extension of the axle - now, the camera rotates with the wheel, so from the camera's point of view the wheel stays in the same relative position - so no trailing. This means that exposures are now only limited by tracking accuracy (and how long it takes for light pollution to saturate the image).
With a fork mounted SCT, the usual way to achieve this is something called an equatorial wedge. This bolts between the fork mount and the tripod, tilting it so that the the azimuth axis points at the celestial pole, and making the mount work as an equatorial mount.
DSLR cameras have the advantage of being relatively cheap (especially secondhand), and can be modified to be more sensitive to h-alpha light (the standard infrared cut filter in front of the sensor also blocks most h-alpha light - replacing this with
something that passes h-alpha makes a big difference for images of many emission nebulae that have h-alpha. The other advantage of DSLRs is that the sensors are big.
Downside is that they're not cooled cameras, which makes the images more noisy - especially in warmer weather.
Astronomical cameras (CCD or CMOS) for long exposure imaging usually include peltier effect coolers - this reduces the sensor temperature by a lot - often tens of degrees, to below freezing point in some cases. Dropping the temperature significantly reduces thermal noise, giving you less noisy images. You can also get monochrome cameras, which make working with narrowband filters easier. Downside is that cooled CCD/CMOS cameras can be very expensive, especially at sensor sizes comparable to DSLRs. Many of the more affordable ones have sensors significantly smaller, and with fewer pixels than DSLRs.