Averted by The Bourne Identity where the Treadstone operative that kills Conklin uses a silenced pistol that sounds rather accurate.

The Boondock Saints have silencers that make a small 'fwip' sound, though they are mainly used to keep others from discovering their activities, not for the element of surprise.

Most noticeable when Kabakov interrogates Muzi.

At several points in the film version of Black Sunday, characters use silenced revolvers.

In The A-Team, an incompetent CIA agent attempts to clumsily put one on his gun while his target complains about him calling it a 'European silencer' when it is in fact called a suppressor.

If anything the sound of the silenced guns is more like a 'pew' than a 'bang' and it's still fairly loud.

Averted in Noir, which took actual audio from the guns used and doesn't completely diminish the sound when a silencer is fitted.

Hirano hands Saya an MP5, warning her that even with a suppressor, any shots will still be audible enough to be heard by them.

Subverted in Gunsmith Cats: Burst when Misty customizes a Python revolver to accept a suppressor, only to be chewed out by Rally because, with the weapon being a revolver, the suppressor has no effect.

And the Welrod is one of quietest firearms ever made. Rather excusable, as the gun in question was the extremely rare Welrod, not something the range they used could have rented them.

Used straight in the anime, as a rare exception to otherwise showing their work with recordings of the exact weapons shown.

Considering someone a floor away from the party but literally an arm's length away from the gun completely failed to notice it, it would still have to be pretty damn quiet.

In one case, the murderer covered up the sound of gunfire by firing the silenced gun at the same time as party poppers were being set off for a party.

Played completely straight when a silencer (and a scarf covering the muzzle flash) lets Pisco fire a gun in a crowded room to bring down a chandelier on his victim without drawing any attention to himself.

The effect is more like a quiet buzzsaw than the usual fwip.

In the same arc a special forces group ambush cartel members with silenced M4 rifles.

Subverted in that we don't actually hear the sound so can't judge how well it worked.

In Black Lagoon during a flashback to Revy's childhood she's shown killing a man eventually revealed to be her own father using a pillow to suppress the sound.

Prey golden gun vs silenced pistol