I use a Kodak DX3900 with a Macro Lence and it works pretty good. You have to learn how to use it tough, I't not easy to take good pictures!
I also have a Sony DSC-S70 which works pretty good. Try to get your self a cam with min of 3.1 megapixel.
www.mindmode.ca
