Substance Painter is definitely my recommended texturing program. I love using it for texturing and while I’m not amazing at it yet, it’s much easier to get results quickly with it. I would first start off by learning how to use it with basic textures. Textures.com will give you everything you need to get started. Once you feel like you’ve progressed enough I would invest in some high quality textures from paid sites like Poliigon, or one of my favorites, GameTextures.