I don't have time to rant about them right now, as I already made an EFFORT POST about Promethean, but I second Manu's love for Exalted, as well as suggest Shadowrun.
A pair of games people may not know so well that are getting new editions "soon"
Scion is a game about Mythology and the modern world. Scion lets you play the children of Gods from various historic Pantheons. At its base power level, it is mildly superhuman, maybe around the level of Xena: Warrior Princess. As the game released new supplements, they increased the power level to be more and more mythical, to the level of juggling battleships and smiting continents.
Trinity Continuum was a trio of games from White Wolf in the late 1990s. They cover three time periods and different settings and genres that are linked in being a single universe, told in reverse. It starts with Trinity, a Science-Fiction game of action and intrigue in the 22nd century where you play a Psion, specifically created psychics with the power to protect the human race from themselves, hostile aliens, and worst of all, the Aberrants. Aberrant is set in the dawn of the 21st century, and is a gritty take on superhumans. It is a game of hope and godlike power with a dark side of taint, the saviors of this era become the monsters of the next. Adventure! is set in the 1920s, and is the first birth of extraordinary individuals. It is Pulp action, globe trotting excitement.