Well it turns out to be the texture not applying properly due to the sculpted mesh, if I try to apply the texture on a clean mesh in Zbrush, then the texture looks as it should in Maya, but it's not the same if applied on a sculpted mesh. So I used a simple Zbrush painting on my sculpted mesh, which was way better, showing much more detail of the sculpt. Thanks for trying to help me though.