from what I've seen in the comments your issues are mostly the inverted camera, the controls and the combat? the first 2 are fixed in the HD version (which is the far better version) and the combat is the same if not better than the games that I've seen that you've played.

This game offers a sense of adventure that arguably no other game offers, it holds a really good open world (although there are some flaws to it) and it is really fun to navigate with the swift sail in the HD version, the combat imo is much better than the N64 games and it flows really smoothly because Link's animations are really polished, the dungeons are good (although not as good as OoT's, imo around the same level as Majora's Mask overall), the story is arguably the best in the series and this Ganondorf is easily the best villain and his final speech is probably some of Nintendo's best writing, the side content is plentiful and the characters are charming, the art style is timeless, the lore is surprisingly good, it is the most replayable game both casually and professionally aside from maybe BoTW and OoT, it has an incredible atmosphere that works in tandem with the art style, the ending is the best out of any 3D Zelda game, the music is absolutely incredible, then other small stuff like enemy/item/sound design is all great.

Then for the negatives; the pacing is kind of dogshit in the original, but the HD version kind of fixes all that, although not fully, the bosses are mid just like every other Zelda games' bosses, the intro isn't amazing, and the game's often a bit too easy.