im using a mod like this for morrowind atm and It makes the game a lot scarier when walking the wild at night.
google atmospheric sound effects by duncan to check it out.
I hope skyrim has something similar.
new vegas had the right idea with the distant gunshots.