It depends how serious the problems were between the couple before they split, but yes, there are more successful relationships after someone has cheated than people realize. Humans make mistakes and emotions in humans can run high and that's when one can make some serious mistakes in their lives. You can usually tell by the person's character if it was just 'one of those things' and they won't do it again, or they are compulsive cheaters.
Never, for a long time an issue is in ones mind will be their inadequacies with dealing with the other person. It may affect one for many relations after the cheating incident, but if you work through the problem then maybe it can be resolved.