Recently I read a quick and clever tutorial, which is: How To Turn Any Photo Into a Realistic Painting Using Standard Photoshop Filters (written by Mickel of Pixel Tango).
I really like the result and I tried to create a Photoshop Action based on that tutorial. In a few minutes later, I got lots of photos with this amazing effect and I think it would be great idea to share it with you. Note that perhaps you may not always like the effect. For that, I suggest you to duplicate your photo layer for back up and make adjustment to its brightness or contrast before you hit the action button.