Funny enough this thread should be here, I came here to post about this. I'm a photo editor / manipulator and colouring in images has to be my favourite. The results are so rewarding, even more so to show people. Here are a few of mine (Rest can be found at www.snayerphotos.com)
They look even better printed on glossy paper :)