I have so many but my top 3 off the top of my head are Disco Elysium, Skyrim, and Borderlands 2.
Skyrim's lore is perfect for a fantasy/sci fi nerd like me (and I haven't even scratched the surface of it yet!). I always enjoyed stories with dragons, knights, and journeys like that.
Disco Elysium is another one because it managers to combine politics with a fantastic story and characters in literally the best way possible. So much replayability and it never gets stale.
Borderlands 2 has the best story out of all the games so far and its gameplay has a fun loop. I like the post apocalyptic setting and villain Handsome Jack for his complexity.