In writing for myself (though publishing might be cool one day) I have found I love to give my heroes "the golden gun"
When it comes to ability, powers, and or badassery. Is the only way to limit
such power: flaws, progressive upgrades, and or one up bad guys? I know the
real reason is my inability to create flaws/ limits.
This is more about writing techniques than creative ideas!
Up until Book three of Spineward Sectors series the Hero pretty much ran the tables. He fought, he bled, he got knocked around to within an inch of his life but always managed to gut out a win. Coming back each time slightly or more than slightly stronger than before.
But in Book 3 things changed for the MC. He still went in with his usual MO. He charged hard, doubled downed on his bets, made all his cool plans and when those were disrupted he lead with his gut. Alas this time he couldn't simply gut it out and the bad guys gunned him down, took his Flag ship, threw him in the brig after realizing he was still alive and not dead as originally expected after being shot in the neck. They then proceeded to abaondon the rest of his heavily outnumbered followers on outlaw station literally crawling with pirates.
Things couldn't seem to get much worse for our hero, and in book four he was dragged up before the the government to be judged for his crimes (tryin to protect the border worlds without official government sanction, at least in their eyes).
I killed off more than a few primary secondary characters, left the audience questioning the survival of the MC and placed him in the power of his enemies.
And that's how I answered the Golden Gun conundrum. He goes in like its any other day and he's going to kick ass and take names. And instead of gutting out the win against long odds, the odds catch up to him and he looses just about everything.
He can still rebuild and come back better than ever when his surviving crew come to bust him out. But no one is crying, oh god, another gimme for the MC, as usual he simply cannot lose. Phenominal cosmic whatever (eye roll).
In this case he can and has lost. So success is not a guarantee.
But do it however you want, there are may roads to rome.
The Deposed King