What does it mean to have "Overpowered" weapons? Is that just when you max out a weapon with smithing and enchantments? Or does it have to do with mods?
Over Powered can apply to many things in this game. The way it is designed, you have the freedom to develop your character anyway you want as you play. The mechanics are in place to let you acquire skill increases as you use them in the normal course of the game. In other words, just playing it, your skills and character will level up as it needs to as you go through the game with little to no grinding.
But, this is the part that allows people to easily create an unbalanced character that can make powerful weapons or armor or potions or sneak or whatever. All someone has to do is Grind and Exploit and they have a character that is way too powerful for what the game throws at them, or worse, they create a character that has high levels, but no combat/defense/recovery skills.
So, play the game, grind out a level or two in skill here and there as needed, and you won't be creating an uber character with uber stuff. Or, if you want to create an uber character with uber stuff, you can. It is all up to you and how you approach things.