I'd argue that it's "hated" because it's simply not good. What it does have is a lot of fan-service, a unique art-style, and superficially interesting combat mechanics.
Speak for yourself. In my opinion it's a far better game than Twilight Princess or Ocarina of Time (considering OoT by today's standards, not 1998's). I have several reasons for this, but in the end it all comes down to opinion.
No 3D Zelda game - hell, no mainline home console Zelda except Zelda 2 - has ever been "not good". They are all fantastic games. Some people like one or another better and a couple of others not so much, but they are all stellar titles.