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.)
Have you ever looked into any randomizers for ALTTP? They’ll give you a whole new experience in playing the game.
With Archipelago, you can even play with other people playing other randomized games. A Hollow Knight player might need you to find their mantis claw so they can get to the boss that has your hookshot and so on.