It is a texturing program. If you have a model that is UVMapped, then substance painter can be used to create and bake texture maps (including normal maps) for that model. Then you can bring the model into a 3D program like Carrara, Poser, Studio, etc. for regular usage. This video might explain it better. https://youtu.be/Qk_YRkDsJrQ