Pushing down on the cable connector crimps the cable together harder and may indicate a bad cable connection at the termination point. It may also get a cold solder joint to connection however you are not isolating the problem.

Pushing sideways on the connector to get the HD to work would indicate a cold solder joint and for the most part remove the possibility of a badly crimped cable.