I doubt that the cable was the problem. Instead it sounds like the drive has a shorted TVS protection diode near the SATA power connector. Repeatedly blasting this short circuit has probably opened up the short. Now your drive has no overvoltage protection, so the next time your PSU misbehaves will be fatal to your data.
... and http://www.users.on.net/