Here are some examples of the types of special effects that can be achieved using the Special Effects Action Set.
Oil Painting
This effect was done on the photo after it was resized for the web, so the effect is NOT nearly as good as it is on larger photos.