I’ve enjoyed playing with the iPhone app called Brushstroke. It’s a pretty versatile app for adding water-color / oil painting effect to photos.
These are three shots I took in different cathedrals on my birthday trip to France, with a little post-processing with Brushstroke.
Notre Dame. Paris:
Cathedral Notre-Dame de Chartres. Chartres: