Well, so far I can say this:
I would love to use Blender, but what I like the least is the lack of clear logic in the procedural manipulations. Sometimes it is just.. well. When I watch a video and hear: “Do this and perform that and you will get this result, I don’t know why but it works” — I can’t take that video seriously.
While Substance gives you the most clear and beautiful results.
So in general: if Blender would have had a reasonable pool of operations for creating textures I would be very very happy. But for now, if you need some guaranteed results — go for Substance.
But I would not dump Blender totally. Cause if you have enough time to spare (fortified with the endless desire to search for the Holy Grail in the procedural deserts of texturing) then you can develop your skills in Blender.
And in the end it will give you the total creative freedom to build up whatever you want.
