Worry not, [Spencer Maroukis] has got you covered with the USB Sleuth Cable Tester! The cable tester is a beautiful black circular PCB, with USB ports of nearly every type on the edges.

In addition to straight continuity, the tester can handle diode testing ... The video below shows that mode in action for finding intermittent cable faults, along with all the other modes.