Those two CD-I Zelda games aren't that bad.
Yes, those cut scene are infamous at how bad the animation/acting is, bit for the time fully animated cut scenes like that were relatively groundbreaking.
The actual game play is pretty standard platforming, and while really hard at times is still kinda fun.
The best parts of those two games however are the soundtracks:
(Sorry, can't embed playlists)
They're pretty techno, and always got me pumped.
As for the 3rd one Zelda's Adventure, that game look like a total borefest with none of the personality or charm of the first two.
Instead of a side scrolling view it's top down, and instead of cool animated cut scenes you mostly get bland, boring voice acting over regular game play.
Here are the few live action cut scenes compiled into a video:
Mostly boring static shots.
Game play looks really boring too. Can't really say for myself though, since I didn't have this one as a kid and the price for used discs was always outrageous.
Here's a taste, though: