Hi,
First off, Canon uses a CMOS sensor on most if not all their DSLRs. It's Nikon that uses CCD but they have changed over to CMOS on their new models. Anyways, this is a moot point to the discussion but I needed to clarify this point.
Regarding the never ending debate over "should I go Nikon or Canon", as stated previously, this is a never ending debate and both will make excellent purchases.
I shoot Nikon and prefer the softer colors of the Nikon lenses. Unless you go and buy the L series Canon lenses, I find that the consumer level Canon lenses are very cheaply made. This is not to say that they won't take good pictures; they do feel very light and not very robust.
For Nikon, good quality lenses won't necessarily run you $1500 + dollars. The most highly sought after 18-200 lens is only $900 and it is a very good lens for general purpose. Canon does not have a lens similar to this....yet.
For Macro photography, the Nikon has 105mm VR version as well as the 60mm version. Both are under $1000 and these 2 lenses in my opinion are perfect for taking tank photos.
If you notice on t.v. you will see that most sports photographers shoot with Canon because of the fast focus tracking on the L quality lenses. But for Nikon you will see a lot more fashion photographers using them for the warm color and realistic skin tones.
Both are companies make good cameras and I would go with the D200 for the price that they are at right now. Although heavier then the Canons, the Nikon feels better balanced and comfortable to hold.
Just my humble opinion.
Cheers,
________
easy vape