Tbh, I never heard of a cable going bad as much as I'm starting to see here. Odd. I worked in a computer store back in the day and we repaired computers and built PCs for sale as well. I think in all my years working their we had maybe two computers with a bad drive cable
I used to think it was nonsense too. I used to visit the Apple Support Communities web site and when some people started posting about it I demanded proof because I just figured these were one-off or obscure problems that rarely happened. Finally some guy came in and verbally beat me up for doubting it because he had his replaced three times in less than two years. As time progressed I saw more and more.
Cable failures can happen but they're typically not common. Years ago I worked on Unix servers with SCSC interfaces and for some reason some of them just loved to develop cable problems too. The symptoms were always similar if not identical to a bad hard drive. The nice thing about them, though, was that they were flat ribbon cables and a lot of times the crimp connector that held the cable in would just lose contact with one of the wires and you could just replace the cable or easily recrimp it in a few minutes.
FYI, Apple, on some of their systems, requires replacing the SATA cable if the drive is changed. I think it's MacBook Air's that use the ZIF type connectors. I think it's posted on iFixit.com but I'm not sure. In that case, if I recall correctly, the cable isn't even really a cable, but more like the types of cables, if you can call them that, that were used internally on older systems like PowerBooks and iBooks using IDE. The wires are actually etched onto a flex cable in a weird pattern that I assume allows the cable to have an impedance similar to that of a normal SATA cable. It surprises me that we haven't heard more about them failing, especially with a ZIF connector, but I don't see a swath of posts about them, so I guess it works.