Should a congressman have to resign just cuz he hit on someone on Craigslist?

Yeah he's married. So what. I know that the guy was a Republican douche, but does cheating mean that you can't legislate?