I’d not really link the Matrix films to Classic Greek story structure, especially not Oedipus Rex.
I mean, Neo dies, but it’s the noble sacrifice. They sort of thing is rare in Greek story structure. Rare in the Tragedies.
It fits some of the Heroic epics.
Dune is a Tragedy in three parts. The Tragedy of Paul Atreides.
Thinking specifically about how both Neo and Paul are blinded at the end.
I had forgotten that, mainly because it played such a minor role in the story.
Paul and Oedipus both accept their blindness as an indication that they had always been blind. They did not see that which they should have.
Not seeing was a major part of their fall. When they return to the story later, it’s as a blind man who finally sees, and one who offers words of advice to their child who is about to make the same mistake that they did.
Then much later, Paul comes back as a ghola, but that part was written by Brian Hubert, who is not the best author.