As this thread shows, there are actually quite a lot. For myself, I generally aim for a natural media look to my images. There are three routes - shaders (such as those sold at RDNA - not cheap but worth is and on sale every now and then), filters (such as photoshop filters or stand alone programs such as Postworkshop Pro), and over painting (I still use my old Painter IX.5 which I can't afford to upgrade, but these days I think that ArtRage is a viable alternative to do the job).

This was an attempt at overpainting...

http://www.renderosity.com/mod/gallery/index.php?image_id=1622488&user_id=221587&np&np

This was an early experiment with the Virtual Painter Plug In...

http://www.renderosity.com/mod/gallery/index.php?image_id=859523&user_id=221587&np&np 

And some of my own styles for PostWorkShop...

http://www.renderosity.com/mod/gallery/index.php?image_id=2029931&user_id=221587&np&np

http://www.renderosity.com/mod/gallery/index.php?image_id=2099480&user_id=221587&np&np

http://www.renderosity.com/mod/gallery/index.php?image_id=2102465&user_id=221587&np&np 

 

Personally, I think that Poser renders lend to this kind of postwork far better than photographs - thanks to what gives rise to the uncanny valley in efforts at photorealism. The trouble with useing a photograph is that it is just too acurate an image and that can limit the illusion but the 3D models that we use, however good they are, don't quite manage that and those little failings help to create the illusion of a drawn/painted image.  

 

 

 

 

 

 

 

http://www.renderosity.com/mod/gallery/index.php?image_id=859523&user_id=221587&np&np