I just felt like reading a dying MC or the possibility of death (if they uses their power). For example: Noblesse
https://www.royalroad.com/fiction/37426/level-up-hero - well, your criteria is just the MC's background of why he was such trash. The MC's superpower is healing, except to "heal", he transfers 1 for 1 his only life energy to the injured person. Thus he really couldn't handle heavy battle wounds, which is all there is when superpowered people fight. Of course, once he gets his cheat after the first few chapters, this problem goes away.
Doesn't quite apply but Trash of the Counts Family deserves an honorable mention, everyone thinks he's dying when he uses his power.
SSS-Class Suicide Hunter - the MC can steal a skill from the person who kills him, of course the first time he uses it, he lucks out and picks up a self revive skill
How bout Left God-Right Demon magic by Tatsuya onii-sama? he practically dying everytime he'd use his magic. Even Miyuki jou-chan as his sister very concern bout it too right? Mahouka Koukou no Rettousei