Extreme fear of heights

Achieved like bats fly. Your arms and fingers have been transformed into wings.

You are now the sexiest thing alive to birds, so they will constantly hit on you.

you lose all leg strength

Only at the speed of walking.

You can't walk

You’re now a city pigeon.

Flying has its own built-in side effects.

Every time you take off, there's a pretty good chance that people nearby will notice. The government will want to study someone who has the ability to fly, so they'll start surveiling the area. Within a short time they'll figure out who you are, and you'll be captured and eventually dissected.

And, that's assuming your flight superpower comes with the ability to breathe at high altitudes, the ability to resist the cold you'd be exposed to by flying, the ability to see while flying without having your eyes dry out, etc.

You get struck by lightning

You can't do it unless you're wearing revealing bondage gear and a ball gag. Your kinks become the story instead of your superpower.