There's so many! Let's see, a few off the top of my head, giving extra weight to stories, and dodging the M rated stuff because I've got no clue what you are and aren't allowed to mess with:
Final Fantasy 7. GREAT story - and several options.
The original game has the full story, and it's a really good one - but it's told by people that look like colored Legos. It's shocking how well Lego-people can stir emotions. The battles are also way less action'y. You can download some modifications to make the game look better, but it's never going to get close to the modern version.
The remake splits the original game into three parts. The first part is on both PC and PS5. Part two is out on PS5 but hasn't shown up for PC yet. Part three is probably a few years away. The graphics are extremely impressive, and they've expanded on and messed with the story some.
The original is on PC (no idea what kind of retro options the PS5 has):
The RPG classic FINAL FANTASY VII returns to PC, now with brand new online features!
store.steampowered.com
The new one:
Cloud Strife, an ex-SOLDIER operative, descends on the mako-powered city of Midgar. The world of the timeless classic FINAL FANTASY VII is reborn, using cutting-edge graphics technology, a new battle system and an additional adventure featuring Yuffie Kisaragi.
store.steampowered.com
Or, if you want a good story where you aren't messing with all these options:
Experience Aloy’s legendary quest to unravel the mysteries of a future Earth ruled by Machines. Use devastating tactical attacks against your prey and explore a majestic open world in this award-winning action RPG!
store.steampowered.com
The story takes some time to get started, but once you scale up that tower, wow!
P.S. The Steam summer sale starts in 9 days. MANY more games will be on sale.