These are what we call the 'YMMV items.' Things that some people find in this work. We call them 'your mileage might vary' because not everyone sees these things in the same way. This starts discussions in the trope lists, a thing we don't want. Please use the discussion page if you'd like to discuss any of these items.
Big Lipped Alligator Moment: A lot of Christopher Walken cameos can come off this way, but this takes the cake (er, pie... whatever). His scene starts of unassumingly enough with him playing a detective there to ask some questions but then he starts talking about pie for no apparent reason, leaves and is never referenced to ever again.
Also, the bit involving Ricki's ex-girlfriend, Robin.
Stanley:Know what I'd like to do? Go down to Marie Calendars get me a big bowl of pie, some ice cream on it. Mmmm good! Put some on ya head! Your tongue would slap your brains out tryin' to get to it! Interested? [lengthy pause] JOHN!?!?
Not to mention the use of the word "heterolingus", which is impossible to utter with a straight face.
Snark Bait: This film is an easy go-to whenever anyone needs a joke about bad movies.
Squick: Louis getting his head blown off into a fishtank and the fish eating pieces of his brains.
So Bad, It's Good: The premium movie channel that got stuck with the broadcasting rights tried to bill it as this. Their ad campaign literally included the phrase "See what's so bad about what people called the worst movie ever!"