Even though Substance is probably a better tool, since it’s made exclusively for texturing work, for sure you can do everything in Blender. It’s like cooking, yeah you can have better ovens and a better kitchen, but it’s the chef that matters. So if you can make the expense then sure, buy the software, if not then you can totally make anything you want with Blender as the tool.
