Genuine nightmare fuel for me is hyper-realistic versions of cartoon characters, but with their features intact. As in, Frieza from Dragon Ball Z in real life, exactly as they are on the show, just in the real world. I bring this up because The Legend of Zelda: Ocarina of Time has several entities that will look cursed in the upcoming remake, given the eye toward realism.
King Zora is one such example. He's a plump fishman who sits atop a waterfall, and unless there's a significant redesign, he'll look like he's auditioning for Guillermo del Toro's Pan's Labyrinth. "I hope the developers possess the courage to extend the length of the cutscene," says a top-rated comment on Reddit, and respectfully, I'm hoping they do not.