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...
Trophy Dark
Recipes on Kmiydish Paper
Good Society
The Shotgun Diaries
Risus
These are 5 TTRPGs I like which together demonstrate the breadth of different ways one can go within the paradigm.
System type, documentation style, distribution of authorial responsibility, the type of story they are...