Adding in my own two cents to this great effortpost.
Four Swords (GBA) - You can only play this if you have 3 friends who each one a copy of the game and a GBA and you have a 4-way link cable. It's probably decently fun like that, but you probably can't set that up. You can play it single-player in the DSi port, but trust me, the game wasn't meant to be played like that, it kind of just sucks.
You could play with 2 players, just like the Anniversary and Switch NSO versions. The levels generate based on the number of players. The Anniversary version also has a solo mode where you can swap between Green and Red.
Oracle of Seasons & Oracle of Ages (GBC) - It's hard to talk about these separately since they're meant to be played back-to-back.
I'd say each game can be described independently. Seasons began as a remake of LoZ and it shows through. It's much more of an "older" Zelda with less narrative, simpler puzzles, and a slightly more open world. Ages is much more of a "3D/Console" Zelda with it's narrative and puzzle emphasis. The games are both built on top of LA, and you're absolutely missing something if you don't play both. The games expect you to play First Game > Second Game, then there's a "Hero Mode" (that doesn't change much) which takes you back Second Game > First Game. I usually play them once, save the Hero Mode PW, and next time I play do Hero Mode.
Phantom Hourglass (DS) - Uses the DS touchscreen controls for everything and has some of the most baby easy dungeons. Also has a dungeon you have to keep repeating sections of each time you progress in the plot,
I want to mention that the dungeon becomes easier with subsequent runs, because you unlock shortcuts with new items. There's a timer of sorts built in, but you can earn more time and there's even a challenge to clear the dungeon with no time elapsed. There's a point where you can double dip and earn two of the plot related items in a single go, which saves time. I never found it as annoying as people make it out to be.
Skyward Sword (Wii) - ....Also has an overworld that's designed more like a set of more linear areas to work through like dungeons, as opposed to being a free and open space, which isn't really a problem to me but some people really hate it.
If you decide to tackle SS after the Oracles and TMC, you'll get what this means. Just as an example, the Eldin Volcano area is not this large volcanic, mountain zone you can freely explore. It's got a very clear and deliberate design that has you progress through the zone. Yes there are secrets to uncover, but you're very much on a set path with clear places to go and things to find. As I recall from interviews, when SS was being made they wanted the overworld to feel like the dungeons to a degree.
Age of Imprisonment (Switch 2) - The same, but now it's just characters from Tears of the Kingdom's flashbacks. I haven't played it.
I'd say the general gameplay is worse than AoC, but it runs a lot better and has a much better presentation.