Finally, cheers.

Fat chance of these ever getting a re-release, but...:

Link: The Faces of Evil (Legacy community wishlist votes)
Zelda: The Wand of Gamelon (Legacy community wishlist votes)

Zelda's Adventure (Legacy community wishlist votes)

Very fat, Nintendo doesn't even acknowledge there existence. I do know that some fans have made remasters of Faces of Evil though.

Ok, this looks terrible... but intentionally terrible, right? Like there's a joke here I'm missing or something.

It's an homage to the terrible Zelda games with awkward, nightmare fuel animated cutscenes produced by Phillips for the CD-i console, so yeah the cinematics are meant to look awful. The game itself however does not play like the games it's copying the style of, it's structured like them, but the action platforming is quite solid and fun.

It looks like a poor Shantae ripoff.

They probably should've leaned on that in writing the ad copy for the store page, then. There's nary an indication in the description or screenshots that it's supposed to be an homage to questionable-quality games/animation of decades past; and the number of people who know of and have nostalgia for the original inspirations, and might also recognize the influences and buy this, can't be high. I, too, assumed the art style was [somehow] in earnest.

The CD-i Zelda games are quite infamous, the animations from them were a common feature in the youtube poop era, they've been meme'd to hell and back, and many prominent online personalities like the AVGN have mocked the games over the last decade.

That said, I agree they should have made it more obvious in the marketing for everyone. I hadn't really though about it until now, but it does feel like the devs assume everyone is already in on the joke, that or they are paranoid about Nintendo's penchant for being insufferably litigious.

Now that you mentioned it, I do remember seeing them in something like that, not AVGN since I never liked his videos, but probably something from Spoony, or maybe some old Nostalgia Critic review of something Nintendo related. But it's very much a "second hand joke" for me. And releasing a whole game (not a particularly cheap one either) based on an old meme seems... well, it's a choice alright.

They're also famous for Youtube sentence mixing videos (known as poops) or animated music videos.

Here's one!

It isn't just one old meme. It was an entire pantheon!

Addendum: This is probably the first game on the Dreamlist I can directly acknowledge as being fulfilled, so well done. One down, 24+ pages to go.
Errata: Also this has as many of the original voice actors as they could get into the project, plus a competent & smooth gameplay system and that funky music too.

https://tvtropes.org/pmwiki/pmwiki.php/Main/StylisticSuck
Where a work is made in an intentionally bad style. Some examples of this trope are In-Universe cases, where a Show Within a Show looks bad, while in other cases the entirety of the work is like this. The most conspicuous aspect of this is the dialog, in which one can expect the characters to speak in a stilted, mechanical tone for no apparent reason at all.

Can often be So Bad, It's Good due to the hilariously bad nature of a lot of these works.

https://tvtropes.org/pmwiki/pmwiki.php/StylisticSuck/VideoGames
Arzette: The Jewel of Faramore was made to be a Spiritual Successor to the Zelda CD-i games. As such, the cutscenes largely emulate the Deranged Animation (complete with characters going constantly Off-Model) and hammy voice acting (with two of the original voice actors from the CD-i games) of the original. The gameplay at least is entirely functional.

That does seem to be a problem with people deep into the Meme-o-sphere: as happens in some other subcultures where tons of people are interested but a much smaller subset are actually deeply invested, those in the latter camp often tend to assume that "everyone knows" about all the deep "lore" of the field in question, just because a bunch of people they know (and lots more they've casually encountered online) are at least somewhat interested in [memes/Internet humor | anime/manga/JRPGs | cars | guns | ... ]. But the nerds (in terms of how "into" the field they are, not in the derogatory sense) often don't have a realistic idea of just how casual/superficial (and sometimes fleeting) that interest is for a large proportion of those "interested" people, outside of maybe a few acquaintances who share their level of investment/passion. I see this all the time online -- including in this forum -- regarding a wide variety of topics of knowledge & interest. I haven't ever really watched his stuff, but didn't his influence/relevance peak closer to fifteen years ago? =D

Basically yeah, back when he had a fake beef with that other video hack, Doug Walker, who also had peaked.