Hello, I recently learned how to use Allegorithmic Substance Designer pretty efficiently, so did a quick demo to show its power inside Unity. The character is just under 6k tri's and is using a 2k texture.

I am by no means a skilled programmer, but I did learn how to create a crappy GUI, expose substance parameters, animate the substance, and write other various scripts to move the camera, change the light intensity, etc. There was "random seed" button I had to randomize every procedural texture to give a "randomized" look to him, but it breaks my scene in the web player...but if anyone knows why that happens and/or has solution, I'd appreciate it! Here is a Unity project (web player) I created to show the change in the texture real time inside of the engine :
http://www.kevindamore.com/Stuff/SubstanceGolem.html
Here is my Zbrush sculpt:

and here is the Substance Designer graph I made to create this texture:
