The reason why some of the guys here keep mentioning Blender, is because you can do everything you just described in Blender, right now. Build your low-poly mesh, sculpt it out into a high-res mesh, unwrap your original low res mesh, create a texture, paint on that texture by painting directly to the 3D model in the 3D…