If you want to take close up pictures of a little cham, or item you would have to get a manual camera.
Both nikon and canon are great.
I used to have a sony alpha and its really good too... but colors are not as real as canon or nikon.
Look for the relfex cameras... those are one of the best ones..
Also... the most important factor in here its the lens that you are using.
The one that you will need its called macro lens, or micro... those are designed for close work and long barrel for close focusing.
maybe 90-105 mm range will make it, but 150-200 would be great!
Also.... its better to get closer to the object than using the optical zoom of your camera... If you zoom in, diaphragm will close up a little bit, and less light will be getting in.
What you want its more light... so... get closer to the object you are shooting instead of zooming in. That way diaphragm will stay open and more light will go thru, and smaller obturation time will be needed.
dont forget to post the pictures

AND your camera too x)