Good news though, since writing this I just started playing with dmesg and smartctl, it actually might be something with the SATA connector. At least those are still pretty cheap.
Nowadays I feel like an underworld scrap goblin, all the old PVRs from family and friends are being cracked open for the HDDs. Time to slink off to my cave of spinning platters.