It depends on the couple. I feel that if you have children and the person who cheated has not done things like this before, then you can try and work past it for the children. Also, if he cheated, there must be a reason. Maybe its based off of your distance, or maybe it was something that was entirly his own problem. If you can figure out this problem, then usually it is somewhat fixable.
But in islam, it says that you have the right to divorce for only a few reasons, and cheating is one of the main reasons. I feel like there are greater sins you can make than cheating, their for, if you are truley sorry, I feel as though Allah would forgive. But I on the other hand could never forget such an action.