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.