I would imagen that you would need to think about your final product to decide what's the best camera for you. If you just want a clear true to life image of your art then you could get away with a good quality P&S like a Canon G5, or a prosumer camera such as a K-M A200. If you want an extreamly high quality image then you need to look into a DSLR like the Canon 20D or the Nikon D1X.
Think about your specific needs then repost and maybe I can be of more help to you...;)
almo