Are people born on the Cancer Leo cusp compatible with people born on other cusps?

That will depend entirely on which other cusp. Like all signs, there are some combinations that will be challenging. When someone is born on a cusp, both signs can have an effect on their personality so cusp/cusp relationships can have more variables than others.