A Mexican oil sector that was feted as the next big thing after a 2013 energy reform has turned into a major worry for offshore contractors and upstream investors.