Have you played Shadows of Doubt? It generates a random city full of NPCs that have jobs, acquaintances, and a home (if they aren't homeless). Then the game picks one and forces them to murder someone else. You're tasked with finding who did it and how, and along the way emergent storytelling happens with what you discover and what you had to do to get the evidence and the culprit.

Played it when it first launched and it was really, really good, if a bit buggy and unoptimised. Content releases leave something to be desired imo, from what I have seen. Haven't played it again since release.