Story driven games

Hey sub! I've been playing a lot of Final Girl, LotR LCG and some Marvel Champions LCGs.

I'm wanting to try find a game that has a more story driven gameplay. I enjoying the campaign questing with LotR and the thematics of Final Girl but hope to find something that has a little more story behind it.

I'm not super concerned about needing specifics mechanics as I like a variety of styles, so long as it fits and is well designed.

I guess to summarise, as a kid I loved the 'choose your own adventure' books, I loved playing D&D and seeing a story unfold based on my decisions, I'm wondering if there's anything like this in game form?