I do agree that some elements of The Matrix do agree with some of Asimov's work. I did enjoy the first Matrix movie and I did see some of the similarities to Asimov's Psychohistory, after that, the 2nd and 3rd movies lost me to a great extent.

"The Foundation" would require a director that wanted to make a work that would make Asimov proud. I have thought about this in the past, and think that a person such as Peter Jackon would probably do well. He did very well with "Lord of the Rings" - staying very close to the original books.