Agreed...it's not a one size fits all answer. No pun intended lol
For me, it was more about him...how open and honest was he? how remorseful was he? Was he willing to be as transparent as needed for as long as it took? Which was the biggie for me...he wasn't. I should have been over it in a couple days. If he's more sorry he got caught, he'll likely do it again and life is too short to live with that nagging little voice in the back of your head wondering what's happening.