I've been having a blast lately, taking macro photos with my Nikon CP950
and then using the pictures as a base to do some painting on top. The
program I've been playing with is "Instant Photo Artist." I then print
them out on my HP 970cxi printer using special inkjet watercolor paper.
Gives a very nice effect and really does look like a watercolor.
Take a look:
http://members.xoom.com/natgold/photos/paintings.html