It seems that I STILL see movies and TV having squealing tires on Dirt roads, Im not sure if this is on purpose! I cant believe that the people adding the sound FX's don't realize this absurdity, so maybe its an inside Industry joke that sound guys keep playing on the unsuspecting public. AlcoveAudio, can you explain this!
Actually, it's become a real PITA for sound designers. Directors "request" certain sounds and as it is their project and their final decision you have to comply. It is also a question of what the audience expects.
Sound design is meant to enhance the visuals, and you have to do many things that run contrary to reality. Real guns do not sound like they do in the movies; people near real shoot-outs often comment on that; "It sounded like a bunch of firecrackers." Windows and auto windshields these days are made of poly-carbonate plastics that sounds like pebbles when the fragments fall on a hard surface, yet we still use the tinkling/crashing glass sounds. There is no sound in space - no air to transmit sound waves - yet all sci-fi films have zooming space ships, etc. Light based weapons - lasers, etc. - would emit no sound whatsoever. Think about it; real cars, no matter how bad the crash, almost never explode and burst into flames; a bullet punctures the body, it would not hurl a person across the room, yet filmmakers use these conventions all the time. BTW, if you are more than 25 to 50 yards away in reality the sound lags behind the visual event; light travels faster then sound. An example of "reality" is the sniper scene in "Saving Private Ryan" (which is a real tour de force in sound design); the German sniper sees Jackson take the shot long before the sound reaches him.
There's a saying in sound design - for a pistol use a rifle, for a rifle use a shotgun, for a shotgun use artillery, for artillery use a tank, for a tank use a bomb, for a bomb use a nuclear explosion, for a nuclear explosion drive down the highway at 90mph with a mic hanging out the window... funny, but true in many ways. Everything needs to be "bigger" than reality; it's partially because the real thing almost never sounds "real" when mixed with dozens of other sound FX and the score. The other reason is that it is our ultimate job is to engage and excite the audience, and let's face it, most of the time reality is pretty boring.
Here's a list of film sound cliches:
http://www.filmsound.org/cliche/