In The Addams Family, the children brew "lemonade" which, when given to Lurch, causes him to breathe a fireball. And since this is Lurch we're talking about, he probably got off light compared to what it would do to a normal human.
In the first Critters one of them swallows a fire cracker; it burps up a flame after it explodes inside of it and it dies.
Played straight in Dumb and Dumber, when Harry and Lloyd laced their traveling companion's diner burger with "atomic" peppers. The result was so intense that it nearly killed him by making his stomach ulcer flare up. Then Harry fed him rat poison - thinking it was his ulcer medication - and actually killed him.
A subplot of A Fine Mess is that Dennis Powell (Howie Mandel) wants to open his own Indian food restaurant that would specialize in curry, although he's never actually tried it before. Dennis's first experience eating curry at a restaurant with Ellen has him downing drinks, eating leaves out of the flowers on the table, running to other customers' tables to drink whatever they have until he finally just starts SCREAMING!
In Rango the title character belches flame on an outlaw's face after ingesting both fermented cactus juice and a lit cigar. The outlaw seems annoyed more than anything else.
In Mel Brooks' Silent Movie the character drive past a Thai restaurant. All the patrons have smoke coming out of their mouths.
The Tag for Scooby-Doo has Shaggy daring Scooby to eat an entire jar of spicy peppers, which causes smoke to come out of his ears and mouth. Finally, when they each eat their own jarfuls, the scene cuts to the exterior of the restaurant, and we hear them screaming as two smoke clouds billow out the windows.
This happens to Roger Rabbit in the opening cartoon Somethins Cookin at the beginning of Who Framed Roger Rabbit. After being forced to drink an entire bottle of Acme Chili Sauce Extra Hot the tea kettle stuck on Rogerss head began to turn bright red like a thermometer. When it turned completely red steam started hissing from it and his overalls, Roger then exploded out of the kettle like a flaming rocket across the kitchen head first into an ironing board.