Mostly in alphabetical order going down my steam list:
Great stories great games: Tales of Symphonia and Vesperia, The Legend of Heroes: Trails in the Sky trilogy, Metal Gear Solid, 2, and 3, Subnautica, Secret of Mana, Legend of Mana, Chrono Trigger, Hollow Knight, Spec Ops: The Line, A Hat in Time, Hades, Doom, Deus Ex, Eternal Sonata, F.E.A.R., FF6, FF13-2, Nier Replicant & Automata, Sleeping Dogs, Undertale, Valkyria Chronicles (admittedly haven't beaten it though).
Mindless fun simple stories: Ys (almost any of them), My Time at Portia or Sandrock, Resident Evil games, Rune Factory 4 and 5, Harvest Moon 64 and Friends of Mineral Town, Stray, Amnesia, Armored Core 6, Have a Nice Death, I am Setsuna, Life is Strange, Neon White, Cyberpunk 2077.
If you had to twist my arm I'd give you these variations of top recommendations.
Best typical JRPG: Tales of Symphonia
Best Metroidvania: Hollow Knight
Best where choices matter: Undertale
Best fps: Spec Ops: The Line
Best comfy story: My Time at Portia
Best environmental storytelling: Subnautica
Best simple stories in stories: A Hat in Time
Best story with a bajillion endings and things to keep playing for: Nier Automata (play Replicant too!)