You can have a photo studio sitting on top your desk.
http://www.jigcraft.com/jigcraft/showthread.php?tid=132
My own version is even a little more compact.
http://www.jigcraft.com/jigcraft/showthread.php?tid=4447
Andylane posted his method a little while back...
http://www.jigcraft.com/jigcraft/showthread.php?tid=4810
I use a 4MP Kodak and think the pics come out great. For crisp/clear close-up photos, set it to macro... flash off... on a small tripod... use a three second timer if available to get your hands of to prevent you from bumping as the picture takes. Still takes a few pictures to get it to come into focus. If it does not want to focus, move the camera back an inch or side to side a few inches and try again. The auto focus can be squirrely some times.
Lighting and color can be tough with the point and shoot type of cameras that try to 'auto adjust' brightness, contrast and color for what is in the picture. Purple is nearly impossible to get the color to look correct on a computer monitor. Take pictures outside whenever you can, but have to adjust your angle to get as few shadows as possible and avoid glare. If you are indoors, the type of light in the room can affect the picture and turn it yellow. If you are taking photos on a white background, make sure you have an object that is solid black somewhere in the picture. It helps to get the brightness balance... then you can just crop it out if you don't want it in the final photo. Had a post on here about it somewhere, but can't find that one at the moment. Have found that fishing lake contour maps are excellent to use as a background - they usually have both black and white in several places on the map..... and it just makes an interesting background to look at.
All my pics go through PhotoShop Elements to crop and final color adjust with the PS auto adjustment features and color cast.
Blah blah blah - i'll stop now.