I believe The Beatles: Rock Band came the closest to being perfect. Eveything about that game was just beautifully done and the only things missing was Pro Drums, an option for Keys, and a few more Beatle songs (Hey Jude, Strawberry Fields Forever, Yesterday etc. etc.)
The FF7 remake. It’s so beautiful, the characters feel authentic, and the battle adaptation works surprisingly well for it.
Honorable mention: God of War (2018). The story is absolutely mesmerizing, if only the combat had more depth it would literally be my top game of all time.