It depends what type of photography you want to do - DSO's or planetary/lunar.
While most scopes can do both fairly well, there are also some more specialised scopes that do some better than others, and as far as cameras are concerned, it's the same deal. You won't find a single camera that can do both well - you need to decide whether you want to shoot DSO's or solar system objects, and buy that camera. Or buy both
As Dave said, webcams are still the #1 choice for planetary/lunar imaging, and depending on your budget, a DSLR or astro CCD camera are the best choice for DSO imaging.
For scopes, aperture always rules, but not if you want widefield images.. There are georgeous widefield images around using an 80mm scope with a DSLR. For planetary/lunar, 8" would probably be the minimum i'd recommend, whether it's a dob or EQ mounted newt or an SCT. Again, depends on your budget and how much patience you have
Hope that helps.