Orion was the first sci-fi and adult novel I ever read. It still holds a special place in my library. As On A Darkling Plain is another one of my favorites, and you can see the beginnings of the novel Jupiter in this book (which is a mashup). Also pretty big on Kinsman, Millennium, Mars, and Return to Mars.
I can't really think of anything of his that would work as a TV show or a movie, though. He's a good writer, if not a little dated by now.