Check out City of Mist. It's urban fantasy noir where players take on the role of Rifts, regular people who have super powers in the flavor of the myth they've been connected to.
It uses the Apocalypse World engine, which means (among other things) that actions effect change on the narrative...