Asklemmy

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

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.

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.

Infinite and unlimited flatulence and defecation. Unlimited fertilizer and methane. Solves the tops soil issue and the energy crisis.

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.

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

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

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.

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?

Being Bullshit man. It gives you power of superhearing, flight, super speed, and ability to call-out bullshit.

Teleporting is absolutely OP, so as mind control. IMO, both should be banned for the sake of discussion.

With that said, spider sense would be cool as fuck.

Hindsight. Always useful. Terrible timing.