As part of demonstrating how this software can be used, I worked on a "just-for-fun" personal project, taking the very cool Solaris model and rendering it with all new textures in Maxwell Render. Below are some of the results:
The original model was made by scifiwarships -- you can see his Blog here and his deviantART page here.
The textures were made in Substance Designer and based off the commercially available Substance Space Ship Hull.
I really love Substance Designer and I highly recommend you give it a look. It is quickly becoming a software that can easily replace Photoshop in many 3D-texturing workflows (including mine).
In addition, I have found the Allegorithmic team to very responsive to feedback and requests -- so if you want to help make Substance Designer a better fit for your texturing workflow go to this link and vote: