This is my favorite of the Zelda games, too! I have never been able to beat it myself, but I'm kind of bad at games, or at least I was when I played it. I've seen my friends beat it multiple times. I love the game play, it was peak Zelda mechanics with the items and fun ways to find how to use them/get around Hyrule. The water and shadow temples are both scary but my fav sections in the game. Also, as annoying as she was, I have a soft spot for Navi and it started my obssession with faries (or did that come from Peter Pan even further back? lol)
Currently, my favorite game is Trails of Cold Steel and all the related Trails of series games. The remake for Trails in the Sky came out and I plan to play that soon, and there are already trailers for the sequel (don't watch the 2nd game's trailer if you haven't beaten the first, it's SPOILERY!)
Another old game I really love is Suikoden. Another one I didn't beat, but I got the remake. I started playing that, and am also not even halfway through Resident Evil 2 with my roommate spurring me along and laughing as I panic at every sound or movement in it. I wish I had more time to play stuff...
I also enjoy the Tales of series of games, not the same set of games as Trails. But both are really great RPGs. In the Tales of series, Abyss and Berseria are my favorites, followed by Xillia.