Player-made superpowers are cool, but how are they made?

Tabletop uses dice systems as conflict resolution mechanisms, so how do we design the best one?

DoNC is primarily built around campaign play, so what tools can be used to encourage this?