Will Cancer and Capricorn will make good friends?

Some definitely will, and the rest won't. Scientific investigation has never produced any reliable evidence that human relationships show any consistent association with astrological phenomena.