Avi,

I wonder if there is a way to tell if a cable is good
*before* you buy it?

Not likely. Your protection is usually a 30 day warranty.
You have my sympathies. In my experience USB, Mini USB, and Micro USB do
not seem to hold up well under lots of insertions. These designs just do not
work well. And they are currently ubiquitous.

Dave M.