This hasn't changed. New "realistic" games still range from horrible to boring-looking. I don't know if it's collective delusion or if I'm missing something.
https://www.youtube.com/watch?v=isvWpUXgKgM
Take this as a compliment, not a criticism when I say you've rigged your proposition by holding up Nintendo first party games, and Shigeru Miyamoto for comparison. If you were to look back at he average Nintendo game, not made by Nintendo, they are mostly unremarkable.
For example, I can clearly see that ray tracing produces better results. But it's a bit harder to tell how better it is, to find the words that describes how better it is. Of course, one can say that, for example, photon tracing is more physically accurate. But still, what words can we use to describe how real (or not real) a still image is ("more realistic" doesn't count :-))
But also, the design often adapts to the capabilities. Games like GTA3 used to have thick fog just to hide the fact that they couldn't render stuff far away in time. You can say that's an artistic choice to give a smoggy big city atmosphere, but clearly it was a practical choice as well. Even today, game designers like to make things dark, blurry and rainy, so that the un-realism becomes less obvious.
The rest, not so much, sure.
It’s basically using the same technique as hand drawn animation where as long as you realize what’s being represented you can automatically fill in missing details. However, this fails as soon as you focus on any one detail.
Honestly, it’s not bad for what it is. I mean the physics engine was probably the worst part, but as a visual demo that’s fine.
Which is something really obvious with the PS5 UE 5 tech demo [0]. The environment looks great and very realistic, while the character is very stylized and looks more like a comic than realistic.
Apart from graphics most stuff in games is pretty rough. Animations are generally bad and ways before reaching the uncanny valley of "getting close"; they're still in the "abstract representation of concept" detail level. AI is dumb (largely for [perceived] player-acceptance reasons). Sound is generally poor; some games still don't use 3D sound. Physics are "abstract representation" level again, some games still have fly-through walls and vibrating items. etc. etc.