Stock sound effects are comically misused sometimes. I think my favorite was in one of the Schwarzenegger movies (True Lies?) a helicopter (with no wheels) lands kinda hard, and you hear a car-tires-screeching-to-a-halt sound.

Also not really an error, but once you recognize a stock sound effect, you'll start hearing it constantly. Like every single time someone sits down to eat, they make the exact same silverware-clanking-against-the-plate sound (especially in shows like Chopped - every time the judges go in for a bite, same clickety-clank.