I remember reading foundation as a young man. Like DUNE I can see the story being hard to dramatise. But of course if they did a season of robot stories the evolution of Asimov's robots and the three laws, like Ringworld and its shared universe, both could be the subject of some fairly amusing stories if done correctly. The Elijah Bailey stories are also ripe for conversion. If I was able to suggest such a series, I would start with an alternative 20th century, where robots have become common place. The anti robot sentiment could build, over the series the years would roll by, the first colonists would leave Earth and Earth itself would begin to break down. Season 2 would be the off world stories years progressing till Elijah Bailey's time. Climax of that seson would be Robots and Empire. Season three more or less Pebble in the sky and that trilogy. Season 4 would deal with the Foundation and the events of the first three books. Season 5 would be the sequels Foundation's edge and Foundation and Earth. The preqels might even be in there too, but I dont know how good they are! The problem with his work is that he was more of a scientist than a Writer, but there is a solid base of writing and story to work to in my opnion.