Although the images I can obtain with my new telescope and CCD camera are better than anything I've achieved before, a good DSLR on a tripod - or held with a steady hand! - can show amazing detail. This photo was taken last night, using my Pentax K3, a 300mm prime and 1.4 converter. Settings were: f7.1, 800 ISO with the 'backlight' feature wound fully left. (AV - aperture priority, auto exposure)
Have a go!