Another book series popular around the time of Foundation was the Lensman series. That would make a decent movie. J. Michael Straczynski, the creator of Babylon 5, was involved in a project to make that movie, but it was just too expensive.
I’ve long advocated those should be made. Now with CGI, it’s possible. Another book into movie I’ll want to see made is Heinlein’s "Have Space Suit, Will Travel”. It’s got everything. Kip, near future all American boy (they can make him black for all I care), who wins a surplus Spacesuit in a contest which he refurbishes and imagines he can talk to, young 12 year old girl STEM genius in trouble called Peewee, kidnapping Wormfaced, people-eating, enemy aliens with evil fellow-traveling human henchmen, heroic good Alien "Mother Thing" who communicates in trilling song that is a silly-putty look-alike, taken to the moon in a literal flying saucer, then escaping, embarking on an almost successful chase across 60 km of moon surface in just two incompatible space suits to Tombaugh Station with insufficient O2 for the three of them, re-captured just as they are staggering to the airlock of Tombaugh and hijacked at high G to Pluto, of all places, then another heroic escape effort, followed by an excursion in the most hostile environment to place a dead and frozen Mother Thing’s beacon out in near absolute zero, Kip then gets there, set’s beacon, and collapses to freeze himself, only to wake up to find himself out in the lesser Megallanic Cloud, looking at the Milky Way and Greater Megallenic Cloud, healing from having frozen to death, and is NOW representing the whole human race on trial for ITS survival along with the Wormfaces under a charge of violence and savagery before the gathered civilizations of three Galaxies! Yup! A rollicking Space Opera if there ever was one!