This might be an older article but it is still definitely worth taking a look at. Over at The Sonic Spread is a great article on Memorable & Iconic Game Sounds. The article starts with:
What makes a sound memorable? Maybe it’s unique or maybe it’s constant repetition. Whatever it is there are reasons why we remember sounds and why they live on to form nostalgia. I was curious about game sounds in particular. There are a good bunch of sounds that everyone seems to recall as either “iconic”, “memorable” or “classic”.
All the way from Angry Birds to Zelda there is some great insight in quality sound design over the course of the last 30+ years.
