My recommendation for this will always be Cyberpunk 2077. There are SO many secrets and sub-plots to discover in the game, and every single one of them feels like an intricate, deliberate piece to the overall puzzle that makes up Night City.
To experience everything requires multiple playthroughs, which I normally dislike in long, narrative-driven games because I lack the attention span needed when it comes to repeating things in games. But CP2077 offers so many new ways to tackle every situation, and it's one of the few games I've played where it truly feels like a new experience on the second and all subsequent playthroughs. The writing and acting are spectacular, and going back and picking different options for various encounters will yield very different, yet authentic results.
I've 100%'d it and still went back and did at least 3 full playthroughs after. I can't sing this game's praises enough.