I think it really depends on the game as well. One of my favourite games (Trespasser) had a ton of ambient sound and only music at particular points. If you watch a movie like "I Am Legend" they also use ambient noise rather than the classic violins/strings to make things scarier.