The best thing possible for Zelda is for it to stay stylized as much as possible. In terms of physics and stuff Zelda seems way farther ahead of Horizon considering that was a seemingly a huge focus for Nintendo's new proprietary engine. Engines are more than renderers...
Looking at some of those 4k images and videos on gamersyde and genuinely not seeing it. Horizon still very much looks like a video game. This is the sort of stuff I think about when it comes to game engine rendering perfectly replicating the crisp look of CGI:
As a video game it's like
holy hell the technical wizardry on display. But still not gonna confuse me with CGI, (especially outside of the photomode).