There's not doubt that Asimov was pretty smart and there are a lot of interesting ideas in the Foundation books. However, I don't think that those will translate to the screen very well. Since the books span many centuries, characters come and go and are mostly not very fleshed out or interesting. Asimov is pretty similar to Lem in this regard, who also was much more interested in ideas than people. Of course, a good screenwriter can make up for that, but you can bet that people will be annoyed by all the additional stuff that is not in the book (like in Soderberg's "Solaris", for instance).
So I'm much more thrilled about Amazon developing a series based on Banks' "Consider Phlebas"...