It comes down to what you are using them for. with photographed textures you will also need normal/roughness/metalness channels for blender, that might not always come with the just photographed texture and you might need to make those yourself.
With substance painter/designer you essentially create what you need similar what you can do inside blender using procedural textures, and you get all the textures maps you need.
similar programs, quixel suite and blender. and it comes down to what you need. personally the stuff i do i’ve found blender and substance to be best for me, i like quixel aswell and you can do amazing things with it.
