Blade Runner comes awfully close. Compare the original movie footage with the replicated 3D version and it's almost impossible to tell.
https://www.youtube.com/watch?v=nQcxEo5MUc8
I'd say, rendering is basically solved. The problem now is animations. Very hard to replicate all micro expressions and imperfections we have come to accept from humans. Even humans with motion capture rigs seem to be insufficient.
That said, what about the John Connor death in Terminator: Dark Fate? What's uncanny about that?
https://www.youtube.com/watch?v=49YHDbdRP0A
Behind the scenes:
I'm not at all saying this isn't all incredible progress, but it seems like it's almost asymptotic to creating a convincing on screen effect?
Thanks all for the links and suggestions for scenes to check out.
No digitally rendered realistic human has ever made it through the uncanny valley. The uncanny valley is to be avoided at all costs, but many digital animators refuse to learn.
Gollum from LOTR worked well because it didn't matter that he was in the uncanny valley. He's supposed to creep you out, it suited his character.