I haven't been out shooting too much lately, but I heard about a new plugin called Pixel Bender for Photoshop CS5. At first, I didn't think about it too much until I was bored one night and tried it on a few photos.
What the plugin does is make a photo "look" like a oil painting. Here are a few of my favorites. You can look in the gallery for the original photo.