CL himself, a popular modder in the Skyrim community, has retextured many of the base game Ebony weapons and turned the designs into incredibly beautiful pieces of weaponry. One common thing you will discover when looking for Skyrim weapon mods is the Ebony weapons are not fan-favorites and could look better - especially when you take into consideration how the armors are awesome. The Silver Sword does not have any particular effects, but it gives you the unique feel of authenticity and spins the world of Skyrim into something different. It simply replaces the Skyrim Silver Sword with one used in The Witcher series, providing the unrelenting strength of Geralt in order to kill the mighty foes he encountered during his adventures.
It is up to you to decide which of these you would rather play with, and how lore-friendly you would like the game to remain. Others add dozens of new swords, bows, and unique gear to the game. Some of these mods are upgrades on already existing weapons. But, once you have played the game several times, or when you are on your first playthrough but have finished most tasks, you will want fresh weapons to add to the quest mods. The arsenal of the Dragonborn is usually something to behold in the latter stages of the game, once you are past level 50 and have the best gear available for the taking.