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.)
I’m a millennial but never played Morrowind. Sounds like something I would enjoy though, will check it out
I suspect that it’s going to be harder for a person to go back to Morrowind from Skyrim than vice versa. You can cheese the hell out of Morrowind and navigation is basically left up to you to figure out (did they add markers in the expansion? I can’t even remember lol). Which on one hand makes it feel much more realistic and you get to know the map more but you can end up wandering around for a half hour saying “where the hell is this goddamn cave??” Once you get immersed into the world though it is really wonderful. There are fewer limitations to what you can do compared to the later games.