Given the large following it is a bit overrated. It’s full of plot holes with time. (Nintendo does not know how time works). To me, plot holes ruin stuff for me.
However, I enjoy playing Ocarina of Time. Not my favorite, but it doesn’t deserve hate. It did give the Zelda series the attention it deserves and put it on the “gaming map”. It was the first game to allow a new form of saving (thank God).
But is it a bit overrated as people claiming it to be the best Zelda game ever and no other Zelda game compares to it? My answer: Yes.