Yes, ever since I was cobbling together Counter Strike maps back when I was in school, I became aware of a bunch of stock sound effects as well (after browsing through them in Hammer Editor numerous times).

When you hear a toilet being flushed in a movie, it is the exact same stock sound. It makes me realize immediately, that I just watched an actor walk in frame (sometimes fidgeting with their belt), while the effect was added later during editing.

Same thing with doors. For a long time, movies and TV shows have pretty much universally used the exact same stock sound of a door being closed. The sound effect is fairly recognizable and about as subtle as the Wilhelm Scream. Sometimes, you can even see that the door is not fully closed, but we still hear the latch snap in place. Sometimes it's also fairly obvious that this kind of door can't possibly produce that kind of sound.

I guess people working at the studios have realized that too at some point, and in the past years increasingly (but not completely) moved to a different, more subtle door sound. It's now become a bit of a "will they/won't they" moment of suspense, whenever I see a door prominently in frame for a character to walk through it.