In the short term, we're still struggling with embarrassing things that we did 5, 10, even 20 years ago. But as time goes by, there is slowly growing acceptance that people do things in private that are publicly considered to be taboo, in bad taste, or crude. One of the interesting things I observed when the Fappening was in the news is that the subjects of the hacking were, by and large, not blamed. The blame was placed on whomever stole the pictures, and few calls for apologies from the various victims were made, and I'm not aware that any of them did apologize for taking the pictures in the first place. Someone is likely to bring them up should any of them run for office, but I don't think voters will care. If anything, it makes them look a little more normal.
When Clinton's reported past drug use was reported (where he claimed not to have inhaled), people made a short fuss and then shrugged their shoulders. Less was made of the younger Bush's drug use, and even less of Obama's. Character imperfections that are shared by a significant minority (or even a majority) of the population are looked past. Where once there was a fear that the only candidates that could run for president were those best able to hide the skeletons in their closets, I think that will fade over time as many of those skeletons won't matter. Within my life, there's a good chance that someone in the White House will get there despite a sex tape being available. A fuss will be made, but ultimately, most people will care more about other matters than that someone recorded their sexual activities.