Substance Painter is all I use for texturing. Just seems more natural and it has a ton of flexibility and power for creating just about anything you want texturing wise. As far as just being for PBR, that’s not true. It can be used for more stylized looks: https://www.allegorithmic.com/blog/stylized-artworks-made-substance
As far as using image editing programs, understand that texturing is really just a 2D image. You can use photoshop to paint on textures onto the UV maps, although I find this to be difficult to really image myself personally that’s why I like 3d texturing programs. I get instant feedback on what I’m seeing in an actual 3d environment.