There is some sort of a sliding scale. But the bar is pretty low in terms of what is sufficiently bad behavior to merit someone losing their position of power.
I'm speaking only of public perception and employment opportunity. Not physical freedom or legal ramifications. I think what Franken did is enough for me to think he should resign.
For me personally, if we're talking about what we might call a minor transgression, the criteria is whether the transgressor tried to silence the woman, or attacked the woman, or did something else to diss the woman, or did something other than own it. If the transgressor did those things, well, I'd be happy to hang'em. But I have a hard time taking the idea of resignation seriously when even the Ethics Committee (which is bad joke, but that's another story) really doesn't have much to look into: (1) she accused him, (2) he apologized to her directly (not just in the media), and (3) she accepted his apology (both directly and in the media). I just don't see what's resignation-worthy about that.**
And before some nitwit claims that I'm saying this just because they assume (correctly) that I agree with Franken on most policy issues, I guarantee you I would say the same exact thing if it was an otherwise-respectable Republican involved in place of Franken even if I thought the Republican was dead wrong about policy matters...
I didn't think much of Franken as a comedian... but I think he's been excellent as a senator... this stuff has me very disappointed in him... my emotional reaction was similar to how I reacted when I heard on the radio that Raffy got busted for roids.... I'm not comparing the two sins, just mentioning that my disappointment was similar: 2 people I thought very highly of, and then I found out they didn't live up to that... left me feeling deflated... I wanted it to be not true, but I couldn't un-know that it was true...
** And neither does she: when asked if she thought he should resign, she shook her head and said she didn't do this to get him to resign, she did it to encourage women to say what happened to them.