Sound effects in games tend to be exaggerated, but making them realistic may help convey more information. There's nothing wrong with either approach, as long as you strike the right balance for your game.