I don't think it is really about showing super powers that is the difficulty, but rather the frequency of the effects shots. Any super-hero show would have to be drama based rather than action based as the effects shots would be limited by the budget.
But creative writers should be able to handle this. Some of the best Trek episodes ever, were bottle episodes with extremely limited effects. It forced the writers to step up their game and not be able to rely on the wow factor.
Exactly. The point is not to duplicate, but to adapt -- to take the idea of superheroes but tell the stories in a different way, one that's tailored for live-action TV. That means focusing more on ideas and characters rather than action and spectacle, but TV science fiction and fantasy have been doing that successfully for generations.