>>21569589As a DM one of the best “conflicts” I ever had in a game was two players having an argument in a Fuddruckers bathroom.
If you have a DM that is a half decent writer and a group of people who are all on the same page, which can be very hard.
You can produce some moments better than anything you see on TV nowadays.
Just remember if you want anything more than just Mindless dungeon crawling and murder hobos get away from D&D and Pathfinder as quickly as you can.
Good DMs and players can make anything work, but systems inherently push and encourage certain behaviors with their mechanics.
You can use a universal system, or one of the many bespoke RPGs that are out there nowadays.
And always remember never let mechanics and systems get in the way of something that's just right and should happen, doesn't matter if it's in combat and dialogue or a plan being crafted.
If it's something you know should happen for the better of the story fuck the rules that's your job as the DM
Depending on your taste I suggest games like.
Delta Green (bonus points if you play it pre 9/11) some of the better written RPG books I've seen and has that wonderful X-Files Vibe before X-Files existed.
Fate: it has a mechanical inbuilt system for building character motivations inherent to gameplay.
The Blade Runner or aliens RPG seems ok, they both have systems built into encouraging players to role play in a certain way.
Mothership: It's sci-fi horror but I don't suggest it for the setting or the mechanics but for two specific reasons.
It has one of the best DM manuals ever made where it doesn't tell you how to use the mechanics DM that specific game, it literally tells you tangible benefits of running and writing a game.
Also Gradient Descent, which is a side module mega dungeon, it is one of the coolest and best written things I've seen related to the RPG game scene ever.