natoround wrote:tried my hardest for a clear set of photos
Thanks for trying

I have a slightly different hypothesis from
fzabkar so feel free to consider both, either one of them, or neither of them - your choice. He might be correct to suspect TVS, or I might be correct, or neither of us...
There's not enough detail of those pins in the photo for me to be sure - IMHO it would need some magnification and removal of shake

However I am concerned that connector pin 10 is shorted to pin 9. There is certainly something
very suspicious in that area of the photo IMHO, which looks like a whisker of metal.
My theory, based on what you said happened and the photos, is that you twisted the power cable while it was still attached to the drive, such that the pins 10 & 9 on the drive were shorted together (i.e. +5V to ground) by a pin on the power cable (probably pin 10), as the power cable was twisted. The plastic of the power connector itself appears damaged near pin 1, which is consistent with the possibility of lateral displacement / twisting of the power cable. I have experienced similar issues on other equipment with edge connectors, where the connector was not mated perpendicularly to the board

Therefore I'm not expecting TVS damage (no overvoltage) - but do carry out the measurements that fzabkar suggested; I could be wrong and he could be right. However if my theory is correct and there is a short on the SATA power connector itself, then the TVS may appear to be shorted when, in fact, it isn't.
Whatever the state of the TVS, that SATA power connector needs attention, or removal / replacement / bypassing, before you next apply power to that drive. There are several options for what to do at that point, depending on what exactly is wrong on closer examination, and on your soldering skills / tools availability / component availability / time availability / risk assesment

I also suggest you look at the power cable which was connected to that drive, when you knocked the cable - do you see any damage to the contacts inside the cable connector which was attached to the drive? You may need a torch & loupe etc. In any case, based on the damage to the drive's power connector, IMHO you
must not use that power cable again, as it cannot be trusted.
Good luck