I accept that if you weren't there for it, you may never appreciate it to its full extent and might easily see it as overrated.
That said, the experience of playing Ocarina of Time in 1998 will likely never be topped, simply because we will never again see a leap as massive as the transition from 2D to 3D. Not only did they invent most of the mechanics still used today, but they somehow got the atmosphere and sense of adventure damn near perfect on their first try.
Thinking you had beaten the game after collecting the three Spiritual Stones, only to pull the Master Sword, wake up seven years in a ruined future, and realise the real journey was just starting, was mind-blowing.
Throw in time travel, the Sheik reveal, the perfect musical score alongside a blend of quirky and creepy encounters, and the game achieved levels of mystery not seen before and rarely replicated since.
Combine all of that with a pre-internet culture where every secret had to be discovered and shared by word of mouth, and it conjured a sense of magic that I don't think will ever be reproduced... Admittedly they came close with the "you can go anywhere" aspect of Breath of the Wild.