As for pure texturing, you have powerful tools to make changes and you get so much repetitive things for “free” so getting substance isn’t going to be a waste. I hope they push blender texturing towards more procedural and nondestructive, then it would start to be contenter for substance.
you said you are gearing towards unity, that also is good thing to get substance and learn. and quite frankly, shaders in substance/blender/unity are similar enough, that you can incorporate everything you learn in one to another software, just being mindfull of their own quirks.
also depending on your project, i regurarly just use blender procedural materials for stuff, since i dont have to unwrap and i don’t take the things out from blender, so knowing that side on blender isnt waste either.
all in all, learn both. 🙂 and quite honestly, once you get into the mindset of shaders and how to work with textures, you blurr the lines on which software to use. and also can ignore all the “this software is best talks”.