As I explained in my post, a lot of people have fun by being challenged by a game. Skyrim is ridiculous in that the player has to impose so many self restrictions and rules to keep the game a challenge otherwise you simply never go close to dying.
Again some people may have fun walking around with 3000 effective health one shotting everything but others don't want that kind of stale gameplay. I try to avoid hitting god mode like the plague on my characters but doing so means I miss out on so much content and features.
your post contradicts itself...some people want to be overpowered so the means is put there for them to do so. Others who enjoy more challenge can CHOOSE not to be overpowered and can raise the difficulty level and avoid certain perks.
You don't want an overpowered crossbow? Don't upgrade it and don't spend perk points on archery damage...simple. You can use your weak crossbow and others can enjoy a maxed out overpowered crossbow, everybody wins

Blame beth for not fixing bugs, don't blame them for giving you the CHOICE to be overpowered or underpowered...thats 1 of the things that makes these games great