The TVTropes Trope Finder is where you can come to ask questions like "Do we have this one?" and "What's the trope about...?" Trying to rediscover a long lost show or other medium but need a little help? Head to Media Finder and try your luck there. Want to propose a new trope? You should be over at You Know, That Thing Where.
No, that's when the power is way more useful than it sounds. I'm talking about when they were genuinely dealt a terrible (or at least non-combat-related) power and still manage to be a badass in spite of effectively being powerless.
Edited by RaustBDI suppose that's the closest we have, though that's really like saying we don't need the Badass Normal trope because we alrady have Muggle, so maybe it's still tropeworthy...
If the allegedly lame power doesn't actually affect them, it could be Informed Flaw.
Do we have a trope for somebody who's technically not a Badass Normal because they do have powers, but the powers are so useless or situational that they often or always have to fight without them, but they still kick ass?