Hey,
I would say that you should definitely give substance a try. If you have good uvs, its pretty easy to get a decent looking result there. But in order to get most out of it, there is still a lot of things to learn.
Procedural effects and all that substance painter magic will only take you about 80% of the way to a finished result, but if you want it too look really good, you will still have to paint a lot of stuff manually. But even when you get there its still easier than hand painting in blender for example (at least I think, I didnt do too much hand painting in blender, I went to substance as soon as I learned that it exists) , because you can paint multiple channels at once. So for example if you want to paint a scratch on something, you can paint the color, height and roughness information at the same time.
Another huge benefit of substance is that if you use fill layers and masks (instead of painting everything in just one paint layer), the whole thing is non-destructive and you can change anything at any time.
