I wish I could describe the near physical pain I feel that "Rendezvous with Rama" isn't yet a great Denise Villeneuve movie, and the "Night's Dawn Trilogy" isn't yet a multi-season series on Apple TV.
Planet of The Apes remakes are not movies, they're just a way to reliably turn 200 million dollars into 300 million dollars - similarly to all the American comic book crap. As long as the multiplier stays above 1.0, the process will continue.
In fairness, IMO the latest Dune(s) were the first that weren't deeply flawed. I do agree that The Mote in God's Eye--and perhaps associated shorts would make a fine basis for a series--hopefully one that ignored the sequels.
Rendezvous with Rama is basically a travelogue. I enjoyed it well enough but there are probably 100s of SF books/stories I would choose to adapt to film before that one. But we'll see. I may well be wrong but the necessary adaptations probably won't be loved by fans.
The list goes on.