Amir, MasterChief has answered for me (I am on a farm with limited access this week). The motor drive is primarily to track objects as the earth moves so you can get the long exposures needed. However, it adds complexity, and a good drive can cost a goodly penny. As for camera mounts, most vendors now provide adapters for Nikon and Canon in addition to the universal T-mount. My friend got one of the CCD systems a few years ago and loves it, but it was an expensive upgrade (I think in the $3k - $5k range for his). Since modern digital SLRs have attained speed (ISO) better than the best film cameras it is less critical but much depends upon what (how far away) the object and how much light-gathering your 'scope provides. Big reflectors do best but littler refractors usually often higher magnification and are arguably easier to use, cheaper, and better for a beginner.
In astronomy, as in many things, you get what you pay for, and it does not pay to go cheap. Not that any of us are worried about you in that regard!
Advice I have seen repeatedly over the years is a close parallel to cameras: buy a decent scope, then get the very best eyepieces (like lenses) you can get. The eyepieces can be used when you upgrade, and you do not want them to be the limiting factor in performance.