Audience-Alienating Premise: Well, title, at least. Because it had the word "porno" in it, TV stations would only run ads for it during the watershed hours and posters mostly bore the nonspecific moniker of Zack and Miri. As a result, it underperformed at the box office.
Crowning Music of Awesome: Live's "Hold Me Up" during the pivotal scene. The music climaxes just as...well...you get the idea.
Seinfeld Is Unfunny: While a modest critical success, the presence of Judd Apatow's cast of regulars drew criticism towards Kevin Smith's filmmaking style, saying that, because Apatow had been making more universally appealing films with a style similar to Smith's, it comes off as desperate.
Squick: "That chick frosted me like I was a fucking cake!" Poor, poor Deacon.