I'm not much of a gamer so I'm sure my suggestions are gonna be normie as hell. I'm also not a shooters girly.
Nier Replicant and Nier Automata are great story driven games if you want to have your heart ripped out of your chest.
I'm also pretty fond of a lot From Software games; dark souls series, Elden Ring, Sekiro: Shadows Die Twice, Bloodborne if you have a play station 4 or 5.... Bloodborne being my favorite, of course.
Older games like Dragon Age Orgins, 2, and Inquisition are pretty fun. The newest one isn't the worst thing in the world, but I prefer the older titles.
I know you said you weren't a big fan of turn based stuff, but Baldur's Gate 3 is a great game.