My very favorite system is Apocalypse World; it always plays out as high-drama operatic pulp. It does tend to go PvP in later sessions, so it's definitely not for every group.

I also enjoy Blades in the Dark, a heist game set in a haunted Victorian London-inspired city. There are a lot of great innovations that mean the players don't have to meticulously plan out their session (often wasting time on contingencies that are irrelevant), and instead can jump right in and get to the juicy bits.

Mothership is a great sci-fi horror OSR (old school revival) game that is very modular and has a ton of pre-written modules. Normally I prefer a more improvised style, but this is a solid ruleset that works well towards building the tension required for the genre.

If you're just looking for a one-shot, Fiasco is always a great time: very rules light and more like a writers room exercise than most RPGs, but there's no better game for hilarious hijinks inspired by films like Fargo or Burn After Reading.

Dogs in the Vineyard is another great one by the same designers as Apocalypse World in which the players are teenage paladin gunslingers in a weird old west populated by demons and heretics. The players come to town with absolute moral authority and may judge whomever they wish, but there's no guarantee they're really the good guys even though their characters absolutely see themselves that way.