I need some advice to choose a Zelda game

[Kriven]

Majora's Mask is by far the best Zelda game in my opinion (Spirit Tracks trails at a distant second). It's full of gut-wrenching aesthetics and side stories, and a cast of supporting characters who are more than just "Random Juggling Dude to Make the Village Look Populated." The dungeons are all fun to explore and unique to themselves, the transformations are on-point and balanced well... you can approach a puzzle multiple ways depending on which Link you want to be.

It is perfecto.

I would avoid starting with ALttP or the origina LoZ if you want to not get frustrated right on out of the franchise. Those games definitely wear their age.