I grew up obsessed with this game at age 7. It was my first adventure game on the N64 which was my first console. Once I played Zelda I knew exactly the kind of games I really enjoyed. I just randomly selected it at a Blockbuster with my mom, fell in love, and then eventually bought it in the year 2002 at GameStop.
Just have memories of my next-door neighbor and me playing it in my basement after a long day of playing outside. All the kids at school knew the game too and would give me tips. This game didn't hold your hand like newer Zelda games so you needed some IRL tips especially since internet wasn't as reliable as it is now.
I have this core memory of turning into an adult in the game one night before school. Seeing how harsh the world became was shocking to me. On an artistic level I'm pretty sure they were trying to convey how it feels to grow up and be an adult. As a kid everything is all sunshine and rainbows (for the most part) as it is with the first 3 dungeons. As an adult the same world that appeared to be sunshine and rainbows is much harsher and expects more out of you which is exactly what happens in OOT. It's a shame there aren't more games that take on this narrative where you grow into adulthood. I thought it made Ocarina of Time one of the most epic games of our time from a narrative point of view. It especially spoke to me as a boy growing up. It invoked genuine feelings in me no other game ever has.
I didnt get to play OOT till 2001/2002 so getting into the game late allowed me to play through Majoras Mask and Wind Waker right after. It seemed clear at the time that Ocarina of Time, Majoras Mask, and Wind Waker were in chronological order until Nintendo made Twilight Princess and they changed up the timeline from there. I still like to think of OOT, MM, and WW as a trilogy though.