Go look at my Gallery, particularly the "Collection" and "Dansco 7070" albums. The pics you see are less than half-size of the originals. I would, immodestly, say that they're pretty good shots.
I use a Digital Rebel with a dedicated Canon 100mm Macro lens. You're probably looking at the Digital Rebel XTi, the newer model of mine. It's likely the "kit" model, including the 28-55 factory lens, and a tremendous all-around value if you're only going to own one camera. That lens will also do very good coin shots, if you set things up carefully because the 28-55 is not a good macro lens. You can expect results similar in size and quality to my Gallery; the Macro lens gives me only the additional size.
I recommend this camera with real enthusiasm. The results speak for themselves. However, if you are planning on dedicating it exclusively for macro photography, I would recommend getting the same model as mine plus the dedicated lens I use. My camera is currently available from reputable online dealers for under $500 without a lens, and the lens I use can be had for just north of $450. There are a couple of other lenses of equal quality and slightly lesser magnification for less money.
If you are in this price range for a good camera, there are a few quality possibilities. I honestly believe that Canon's solution is better than the rest, because of the excellent lenses available. However, Nikon and Sony also have good entries in this field.
I must be honest with you. This price range is a step up in quality, and also a step up in knowledge and effort required to maximize the potential of the camera. You will still get stuffpy results if you put stuffpy effort into doing it, and you will then be out $1000 and unsatisfied with your results. Spend the money if you wish, but be prepared to learn to use your excellent new toy. It would be my pleasure to help.