it really depends on the style your going for and the type of textures you want to make. it also helps if your artistic. blender is good for creating textures from sculpts / models, and with its node system you can create some good stuff. kryta and gimp are also good for painting and modifying textures. if i were to compare using blender to something like substance (i havent used substance but ive seen a few videos) i would say that you could probably get similar results but it may take a bit more work with blender.