Can a person's own fear of being alone actually push love further away?

Is it better to walk away from a cheating partner than to force them to end an affair? What do people who've been through it think?
I became best friends with my spouse before we got married. That’s how we met. Is that a great thing?