I've had SATA drives appear dead only to come back when the connectors are re-seated. I think this is a design flaw in the SATA connector system. The contact area is too small with not enough pressure.
Is there any way of solving this problem?
With the amount of noise the drive seemed to be making I would suggest just replacing it.