The best solution is the tool or a combination of tools which gives you the best result in a minimal amount of time, and you have fun doing it.
The old school method i use everytime: Photoshop.
Photoshop is the hub, where the layers and elements get assembled.
But for 2d painting on the texture itself i often use Krita. Especially for characters because of the symmetry tool, and for tileable textures because of the tile workflow.
If i want to paint directly on the model i use either Mari for very complex models with UDIMs and high texture resolution, or Substance Painter.
For hard surface tiles, panels, modular pieces i use Substance Designer.
I also create my own substances to use in Painter. Sometimes i consume illegal substances while i design substances with substance designer.
I also use quixel NDO from time to time to convert drawn height maps to normal maps.
I haven't had the time or motivation to learn the DDO drawing workflow.
Maybe i should.
My faverorite workflow is to switch inbetween all these tools and find the best one for the actual job. Or the one my computer handles flawless without hiccup.