Joshua Lynch, and environment artist on PolyCount, has been posting the best looking Substances I’ve ever seen.
Take a look: http://www.polycount.com/forum/showthread.php?t=145615
So very, very inspring. It’s incredible to see what’s possible with this toolset. Here is a sample: Remember, this is all procedural.