I believe automatone’s advice is partially accurate but helpful nonetheless;
When you use a standard point-and-shoot, you have the issue of parallax error: the inconsistency that comes from having a separate viewfinder from the main aperture; makes difficult to tell how you are actually framing the artwork.
Although non-SLR (‘point and shoot’) cameras do come with a live preview, many of them have lenses that are aspherical, which produce the edge distortion described above. Even with live preview, you still will have to contend with that issue when framing images. Most Macro lenses are designed to combat the edge distortion issue, but can be pricey and sometimes less-than-ideal optics when used as adapters on point-and-shoot cameras-which is why you end up going with SLRs in the first place (switchable lenses). Leica lenses are non-aspherical (and pricey) but Canon, Olympus, Nikon, Sony, etc. all have entry level macro lenses that work with their D-SLRs.
That said, my wife finds that her Canon Rebel xti (EOS 400D) is awesome with a 55m macro lens-very little edge distortion, and she can take images from 1” away! Also, even though you can’t have live preview, the LCD display can be set to do a post view where it stays on the LCD screen for 3 seconds after the photo is taken. Also comparable is the Nikon D-40/80, but you can do your own comparison research on cnet…
Haven’t tried this but you may also be able to hook up a computer (tethered to a laptop for example) directly to the camera and do post view while photographing on the computer display with the right add-on software…
From a cursory google search I found this to be a helpful primer…feel free to correct me if I’m wrong on any of this-I’m no photog expert-but I did do a bit of research this time last year when I purchased the rebel for my wifey for x-mas :) I think the body is down to $250, and lenses about the same!! Good luck on your research.