How about half-powers, which takes only one part of a known superpower and throws away the complimentary "other" power people tend to disregard.
The power to pause time, but the inability to start time up again.
The power to cause a storm, but the inability to control it.
The power to shift into anything, but be unable to reason as your former self once you shift into something.
Really, take away the "return to normal" part of the superpower, and you have a useless superpower. There are some exceptions (super strength), but a superpower can also be called useless if it hinders the user's way of life as well, which could easily happen with a power that is active all the time.