I quite like the silver weapons, but it seems to me that they do kind of reach redundancy before long if you follow the smithing route - as I do.
I'm kind of surprised they didn't do more with silver weapons in Skyrim.
One of the key features of Bloodmoon in my mind was how the Skaal had all of those 'Nordic Silver' weapons (axes, swords, claymores, battleaxes, etc.) - particularly due to the lycanthrope threat.
Then we got stuck with only 2 types of silver weapons that could not be upgraded - and the only group of 'werewolf hunters' are considered to be evil lowlifes.
Anyways, they're still cool weapons, I just wish more was done with 'silver weapons' in general.