A lot of people in this thread already recommended some Forged In The Dark games, so I won’t retread that ground, but Blades in the Dark, and the sci-fi hack of it, Scum and Villainy, are both excellent.
My absolute favorite TTRPG is Fiasco. I’m not sure how many others would agree with that, but I’ve loved Fiasco from the first time I played it, simply because there really aren’t any strict mechanics you need to follow. In TTRPGs, my favorite thing is character interaction, and having moments together, where the characters get to talk, and not have to roll dice to determine anything, and that’s Fiasco to a T. Of course, you roll dice in the game, but all the dice are really used for is to set the scene of the game (determine who your character is, what their relationships are with the other players, what they need out of the situation they’re in). Fiasco is a role playing game in the purest sense of the phrase. It’s more akin to improv than D&D. I love building these over the top characters, plopping them into intense situations, and having improvised dramatic arguments with my friends while we’re pretending to rob a bank or something. No dice roles to determine if we succeed or fail in unlocking the vault or not, just pure roleplaying.
Some people like the more crunchy side of TTRPGs, with pages and pages of rules you need to memorize, and I have love for those games too, but there’s something about Fiasco that helps me get lost in a character and a setting better than any other TTRPG I’ve ever played.