I thought "Same Time Next Year," with Alan Alda and Ellyn Burstyn (I think?) was a great, albeit immoral, movie. I love how Alda's character always says "OK, so I didn't think things thru . . . "

"Unfaithful" is another one that comes to mind.

Puppy