A Dutch insurance company, known for their slogan "Even Apeldoorn bellen" ("Time to call Apeldoorn", the name of the city where they have their main office) has a number of rather clever TV ads. In one, two roadworkers are digging a rather large hole (the road is at chest level); one of them is wielding a pickaxe. Then a stunning pair of legs walks by (that's roughly what you see, due to the camera crop), the guys look at them approvingly, the pickaxe swings down once more, a metallic "clunk" is heard and a jet of water spouts up. Slogan text blends in.
A 2000 ad for Kronenbourg 1664 beer took this up to eleven. It starts out with one awe-struck construction worker obliviously swinging a pickaxe while gazing at a woman, while another equally oblivious worker climbs out of a manhole in front of him. Cue a quick camera change and a sickening squish noise. It goes on like this for forty seconds, with butchers slicing off fingers, men getting hit by busses, and utility workers getting electrocuted.
Subverted, since they actually want her beer.
Air New Zealand Safety Videos: The guys demonstrating the brace positions in a canoe in "Safety in Paradise" keep sneaking glances at the model in the bikini on the beach.
The first commercial for the Sega Dreamcast in America ended with Sonic the Hedgehog losing his balance from the on-light of the Dreamcast and falling, ready to be caught by a football player, only for Sarah to walk by, distracting the player and causing Sonic to faceplant on the ground, losing rings in the process.
Bill Engvall discusses looking at colleges with his daughter:
Bill Engvall: I'll tell you, it's a real slap in the face when you walk onto a college campus with your daughter and you catch some guy checking her out. (murmurs of agreement) Yeah. Then I realized it was a slap in the face; my wife caught me checking out college chicks. (laughter) "Sorry, I'm a guy."
A man is walking with his wife when he sees a young woman in a Dangerously Short Skirt getting into a bus and keeps looking. His wife tells him acidly "I suppose you think I didn't catch you staring at the girl getting in the bus?" "What bus?"
In Lil Abner, "Stupefyin' Jones" stunned any male who gazed upon her, except if they were wearing special glasses. In the stage and movie adaptation, she was played by Julie Newmar in a skimpy skintight body suit.
In this strip◊ by Quino, a man is watching a football match, when he's distracted by the fact that his neighbor forgot to close her window when she went to take a bath. Just then, one of the teams scores a very dramatic goal. He's so enraged at missing it that he throws his drink through the window and hits the neighbor in the head.
"What Was I Thinkin'" by Dierks Bentley covers this trope pretty well.
"Baby's Got Her Blue Jeans On" by Mel McDaniel is a good example of this.
"Bettina, zieh dir bitte etwas an" (Bettina, put some clothes on) by Fettes Brot has the chorus "Bettina, wrap up your boobs". The song was inspired by the outfit of the host in a late night, call-in TV game show.
The singer of "Man On A Mission" in !HERO: The Rock Opera ends the song with "Who's that beautiful girl?", segueing into "Secrets Of The Heart".
"Long Cool Woman (In A Black Dress)" by The Hollies. An FBI agent is about to signal a raid on a Bad-Guy Bar but the eponymous woman catches his eye:
"Bigger Than the Beatles" by Joe Diffie has a mutual example of this. A waitress in a bar and a musician who performs in the bar are very much in love. Sometimes she forgets an order because she's thinking about how handsome he is, and sometimes he forgets to sing a chorus because he's thinking about how beautiful she is.
"Crush On You" by Bruce Springsteen. The narrator is constantly getting distracted by beautiful girls to the point of wanting to drop everything and just run after them.
Also these lines from "Loose Change":
Yeah, I knew she was trouble but trouble sure was lookin' fine
When I pulled her close what I knew kinda slipped my mind
Eric Schwartz's "Kosha Boy", a parody of "Soulja Boy", has the Kosha Boy "try to set an example", but he gets distracted by "the girl [he wants] to schtup in the third row."
In the Mutants & Masterminds supplement about Japanese media Mecha & Manga, there's a feat called "Distracting Looks" that allows your character to provoke this reaction to reduce targets' effectiveness with social skills.
In the Dungeons & Dragons 3.5 supplement Fiendish Codex I: Hordes of the Abyss, one of the Abyssal Heritor feats is "Otherworldly Countenance", which allows to choose between wretchedly hideous or stunningly beautiful. If beautiful, the character can cause a fascination effect a set number of time per day by focusing attention on a subject. Note that no mention is made of the subject needing to be of the opposite sex (or even the same species, in fact).
As the Man in Chair tells us, the actress in the 1920s musical The Drowsy Chaperone was famous for playing "The Oops Girl", who had this as her entire shtick.