http://skyrim.nexusmods.com/mods/45314//?

This mod overhauls the sounds used by melee weapons and archery. Mainly draw, sheathe, swing and impact sounds are affected for melee. For archery, the sounds for bow pulling & firing, as well as arrow impacts have been overhauled. Most sounds have been completely redone from scratch, while a few retain elements of the original where I felt it was appropriate.

They are not neccessarily better or worse as it comes down to taste (There are some stylistic differences like more pronounced armor/clothing foley sounds when moving your arms), but they are without question more varied. Skyrim's sound playback uses a system where it can cycle between more than 1 sound for the same action, to reduce repetition. Some sounds were less varied than others however, so I have focused on adding more variety to certain sounds. For example, drawing a dagger only used 1 sound originally, but with this mod it now uses 3 different variants. Skyrim also only used 3 sounds for firing arrows originally, which is upped to 5 in this mod. There are many more additions I can't be bothered to list here.

Yes, this will increase your memory usage. But we are only talking about a few megabytes at most, so it should be negligible.