Fridge Horror: It is very likely the entire reason Woogie not only befriended Ted but became his best friend was to eventually use him to get to Mary. Not only that, but he always resented him because Ted (in Woogie's mind) stole Mary from him.
There is also the fact that he never loved his wife and kids.
Not Sure if Brett Favre being in love with Mary in the movie counts as this or a "Funny Aneurysm" Moment after his habbit of texting pictures of his junk to blonde women was exposed in real life.
Too Dumb to Live: The only reason that Mary broke up with Brett was because she received a letter from Tucker informing her of how he felt about Mary's brother. She then gets the similar treatment regarding Pat Healy when Tucker mentions Healy's fake past. And then again when he sends her a letter about Ted. (Though it later turned out to be Woogie's doing). How did she not think Tucker or someone was sabotaging her relationships out of jealousy or because they were in love with her and trying to remove the hypotenuses?
Mary Sue: Possibly lampshaded with Mary, as her name is literally Mary. She is always portrayed in a positive light and throughout the film multiple guys lie and cheat their way in other to have some form of a chance of dating her.
Never Live It Down: Implied by Dom when he mentions that he knew about Ted's zipper incident because he was "only" four towns away.
Nightmare Fuel: The fate of Sully in the extended version. He gets eaten by his pet boa constrictor, Bill.
One-Scene Wonder: Keith David as Mary's stepfather. And the police officer who's going to break Ted. Harland Williams as the serial killer who's going to sell seven minute abs.
The Woobie: Ted, especially during the zipper scene and towards the end of the film.