>>356659032
Photoshop goes a long way and is based.
But for the finer detail work of building from scratch, substance painter is almost essential unless you want to paint in blender itself which is a pain in the ass.