There’s still an insane amount of things you can do in Photoshop, but for painting textures? It’s pretty much been replaced by Substance Painter and ZBrush because they allow you to paint right on the 3d model. You’ll mostly use it for things like padding borders and color correction.