Billy Joel’s Allentown started with a steam whistle, and the clanging of a pile driver runs through the whole song. Onstage, the clanging was a band member whacking a long steel pipe.
Pink Floyd’s Grantchester Meadows starts and ends with a buzzing fly, which is swatted at the end.
“Paper Planes” by Maya Arulpragasam - gun shots and register bells as lyrics
“Rock the Casbah” by The clash has, what I believe are, sound effects from a PAC MAN game watch.
You May Be Right starts with breaking glass.
The Zombies – The Way I Feel Inside
Footsteps at the beginning and either a coin or a ring being thrown on the bar and walking off. I’m guessing it’s an engagement ring and he got turned down. Now I’m all teary.
Two more Billy Joel:
“Goodnight Saigon”-Helicopter
“Moving Out”-motorcycle revving
“LA Woman” by the Doors starts with an engine.
Arcadia’s - Lady Ice. Sounds like giants walking.
The Typewriter - Leroy Anderson
Pink Floyd – “Alan’s Psychedelic Breakfast” (various sounds of breakfast being made)
Pink Floyd – “Atom Heart Mother” (several sounds, but most noticeable is the sound of a motorcycle.
Pink Floyd – “Echoes” (sound of sonar)
Beatles – “Maxwell’s Silver Hammer” (a hammer hitting an anvil).
Bonzo Dog Band – “Shirt” (man in the street interviews)
Bonzo Dog Band – “Postcards” (the sound of a person discretely vomit after the line “the captain says he’s going to heave to.”)
Bonzo Dog Band – “Cool Britannia” (ends with the sound of someone grunting, something plopping into water, and a woman laughing.)
Bonzo Dog Band – “By a Waterfall” (water being poured into a glass).
O-Zone’s Dragostea Din Tei (more commonly known as the Numa Numa song) has a cellphone ring at one point.
ELO-Telephone Line phone ringing
Afternoon Delight has a stupid airplane effect, which has pissed me off since I was a kid because the lyrics mention skyrockets, not planes!
Starship-*We Built This City *radio traffic report/station promo.
Kesha’s “Dinosaur” begins with the (hypothetical) sounnd of a dinosaur roaring.
“Good Morning Good Morning” has all kinds of sound effects, including the rooster crow that starts the song. “You Never Give Me Your Money” fades to sound effects of night sounds, crickets chirping type stuff.
Both by the Beatles, of course.
Thanks for clarifying the hypotheticality of it. 
mmm
1812 Overture count, with the cannons and stuff?
Not specific songs, but Buddy Holly’s band was called The Crickets after a real cricket. They had stuffed a garage with insulation to make their earliest recordings, and they never could find the cricket audible on every track.
Leader of the Pack, The Shangri-Las
Also, Remember, same group. Seagulls, ocean.