I wanna recommend Vampire: The Masquerade - Bloodlines. A flawed gem of a game. The graphics are ugly, the combat is clunky and it's the devil's job trying to get it to run on a modern PC. BUT the story, the characters, the voice acting, the atmosphere, the setting and the little touches makes it all okay.
You're a fledgling vampire (who doesn't glitter) thrown into the chaotic politics of a city on the brink of unrest. Humans scurry up and down the street like cattle, not knowing that the end times are near and that their lives are only their own until someone wants them as their plaything.
You're taken under the wing of the leader of the city and given a few odd jobs to prove your worth. Solve them with brute force, stealth or diplomacy. Use your vampiric powers to gain the upper hand whichever way you choose to solve a problem, but most importantly: Do not betray the Masquerade. The cattle must not know of your presence in society.