Modern Zelda's issues aren't the visuals...
Considering Windwaker is one of the very best in the series, gritty realism isn't what makes a great zelda game.
I do wish one day we get a real modern Zelda game that marries a Semi-open world, metroidvania style with modern designs...
sadly God of War 2018 was the closest thing we've had to a Zelda game since TP.
I would love a From Software-designed world map, the likes of Dark Souls, Bloodborne (not Elden ring) for a new Zelda game. Worlds that feel open, lots of meaningful exploration that wraps in on itself cleverly and makes you feel a sense of progression and reward.
Alas we are stuck with Bonky's Minecraft lands Zelda games it seems going forward, which stinks... But someone will pick up the torch eventually and create a new game, albeit in spirit.