I just bought a new camera. I wanted it primarily for taking pics of my tank. My friend is a photographer, so I asked his advice. His suggestion was to look for the highest amount of megapixels I can afford. He said at least 6 megapixels if I want good color. He also suggested a camera that has a macro option. Some digital cameras have a macro option. A better option would probably be to go with a camera that you can switch the lenses. You would probably have to buy the macro lens seperately, and they can be pricey. I opted for the clearance model at Wal-Mart. I got a sony digital camera with 7.3 megapixels and a macro option. It cost me $150, plus $70 for a 2gig memory card that holds 600 pictures. The only thing I don't like about it is that I can't focus on extremely tiny objects. For the price, I'm pretty happy with what I got. It also takes video.
Here are some pics I took with my new camera so you can get an idea. HTH
This is my seahorse Banana:

Here's a shot of my new zoas:

New dragon eye zoas on bottom right and
lettuce sea slug attached to the glass:

Shot of new dragon eyes under actinics lights:

I just bought the camera about a week ago, so I'm still trying to figure out all the options and settings on it. I believe these pics were taken with the macro option. It has like 7 different settings on it.