Hey,
I may of first heard of this soft in these forums, don't recall, but its on sale now.
http://quixel.se (texturing 3d)
Works with photoshop. Pretty impressive looking. Make sure to take a look at the video links in the page I posted above.
Here is one that shows a pretty nice looking work flow https://www.youtube.com/watch?v=WirF2bV8iNk