I am going to respectfully disagree with the people who posted before me who said the question was too vague and meaningless. I did see a specific question in the OP and I have a specific answer.
To play as an "ordinary character" I am going to recommend three mods: Requiem, Alternative Start and The Notice Board.
http://www.nexusmods.com/skyrim/mods/19281/?delevels the world to make you start out as an ordinary citizen, rather than an overpowered person who can take on nearly everything in the game at first level. You start out weak and very ordinary. But the world is deleveled, so as you increase your character's perks, skills and attributes, the world will not scale with you as it does in the vanilla game. The world remains the same throughout the game, so you don't feel like the world is revolving around your character. Rather you are an ordinary person who may or may not advance to a position of great power, depending on how you play and where you put your perks.
http://www.nexusmods.com/skyrim/mods/9557/? lets you start somewhere else other than Helgan (you have many options where to start) so you can avoid the "Dragonborn" trope entirely and just start playing as an ordinary person.
Finally http://www.nexusmods.com/skyrim/mods/70142/?, will provide things to do other than Skyrims vanilla questlines, which for the most part all suffer from "chosen one" syndrome. The Notice Board adds an endless supply of radiant quests you can pick and choose from.
Personally, I would not want to play without these three mods in my load order, in large part because they make characters start out "ordinary" and give them the option to remain ordinary or become extraordinary.
EDIT, because the OP mentioned weapon smithing, I will add recommendations for Complete Crafting Overhaul, Weapon and Armor Fixes and Clothing and Clutter Fixes by Kryptopyr with the Requiem patches for each made by Unmeix. That combination makes smithing more interesting.