The New Oil Paint Filter

Photoshop CS6 comes with a new filter based on the Pixel Bender plugin, which allows for anything from soft to dramatic oil painting like effects.

This video takes a detailed look at the options in the filter.