For me Lore doesn't matter. When you jump around 200 or more years between game realities lore gets murky. If I do take time to read the books found ingame I don't ever take them as lore, I take them as just stories.
With that in mind I find the artifacts/unique gear/deadric gear completely useless and worth nothing more than what you can sell them for. When you can make dragonbone weapons that do far more damage (with just leveling smithing and the elixers you buy, not craft or glitch) than the quest rewards, they become a joke. Why not at least make them at the same damage level as dragonbone? At least they'd have a use other than pretty decorations. Not talking about making them "overpowered", but on par with what you can craft without using any glitches.
You already can improve most artifacts to make them "on par." Unless you're talking about making their enchantments stronger or something, I'm not getting what you're talking about. You already can make them usable.
Weapon damage in this game is a joke. My level 81 character beats down legendary dragons with wooden swords without breaking a sweat. I have another level 55 character who kills Briarhearts on Master in 3 swings. NEITHER of these characters(none of mine, actually) use the resto-potion loop exploit glitches, just level 100 in the necessary skills through normal play. I gave up using both of these characters a long time ago due to how easy the game became. I also have a level 40 character who has used a simple steel greatsword almost the entire time, only recently upgrading to Skyforge steel. It's been much more fun and rewarding.
This game is not all about min/maxing and high damage. Game-breaking power levels can be obtained ridiculously easy.
I don't think many of you even want to play "TES V: Skyrim"... You just want "Fantasy RPG Simulator 5000." Instead of role-playing a character in an existing environment, you want to role-play the entire environment to cater to your every whim, like spoiled children. If you can mod it on PC to achieve your goals, then by all means have at it. The rest of us on console have to be a little more humble and work with what we've got.