In power trip novels, MC's usually can handle all and their abilities can solve any problem. That's boring. How about an mc that is super specialised. Like, give them a problem that is up their alley and they will destroy it. But give them a problem outside their specialty, and they gonna get owned like a noob. Like, mc is super good at making poisons, but a fist to their face will kill them anyway. Or, mc is great at fire magic, but they are a glass cannon, needing to flee once they are done firing. And they can't handle water-based attacks. It must feel that mc is weak against something that has a good chance of showing up all the time
cale from tcf lol, he has like 5 elemental ancient super-powers (wood, wind, water, fire, rock) but will cough up blood or faint (for 3 days or more) whenever he uses it
One that immediately comes to mind: The Exiled Villainess Returns https://www.scribblehub.com/series/112235/the-exiled-villainess-returns/ The MC is powerful when it comes to magic but her magic power isn't unlimited. Also, slap an antimagic device on her or around her, then she's a sitting duck. Unfortunately, she had to learn that the hard way, of course. And so, like every strong MC, she tried to find a way to fix her weakness, and it works somewhat until BAMMM pregnancy pain renders her physically useless and baby in the tummy sucking all her magic power and she becomes a sitting duck again. The writing is funny though so I just can't help but laugh at her pain If I have to say what exactly is her weakness, it would be "real life is simply a d**k".