Asklemmy

JoJo's Bizarre Adventures proposes a couple of interesting . One villain has a power called "The Lovers" he manifests a tiny ,almost microscopic, insect creature which is physically very very weak (or at least the weakest we have seen at that point), but has the ability of going crazy whenever the stand user feels any kind of pain, so he sends the stand inside an opponents ear to their brain and pain centre – whenever he feels any pain The Lovers inflicts that same pain but much worse on his opponent. It's also heavily implied that any pain caused by The Lovers that is above a certain level would be lethal.

Super weak power that is actually really strong if used intelligently.

Being able to breathe underwater, no boosts to handling pressures and no talking to fish. You can’t go rescue dumb submarines, you still swim slower than any trained seal or dolphin, and cleaning the office fish tank doesn’t require swimming.

Being able to teleport only 1 foot away

Seems useless until you realize that it can absolutely come in clutch if you're ever physically stuck anywhere

First thing that comes to mind is RocketJump's video Milk Man: World's Worst Superhero. Essentially, his power is drinking and regurgitating milk. While this sounds lame, he actually manages to disarm and incapacitate the robber, fly, and give the distressed citizen a nice, refreshing beverage. Sounds pretty useful to me.

Now, only one question remains: Got Milk?

Clumsy Vision. You shoot rays out of your eyes that make the person mildly clumsy for a few minutes. Not like Slapstick Comedy levels of clumsiness, but just like tripping over their shoelaces or looking back and running into a pole clumsy.

You've won a few battles (like that time the purse thief mistook you for an A lister superhero, ran away, tripped over their own feet, and twisted their ankle), but you're mostly useful for anything other than occasionally stopping petty criminal behavior.

The ability to boil eggs by looking at them. Always the same consistency which is slightly too hard for your own tastes.

Super hearing. I probably wouldn't tell them that it gave me super tinnitus

Hindsight. Always useful. Terrible timing.

There's a Marvel character who's "super" power is that he is instantly forgotten by everyone the moment they don't see him anymore. Seems like a pretty shitty predicament but it can be very useful.