For super real textures front projection can't be beat. With this feature a texture can be projected face on to the model. To my knowledge only substance painter blender and Modo support this.
Quixel mixer is another free alternative texture painting app. It works beautifully with quixels library of textures, but which are not free unless you own unreal.
Quixel mixer is another free alternative texture painting app. It works beautifully with quixels library of textures, but which are not free unless you own unreal.