Dune (1984) would be up there, if you read the book first.
2001 is also a notable achievement. I saw that 4 times before I read the book. Never understood it until I read the book. A. C. Clarke was a genius. His "songs of distant earth" needs to be made into a film.
Planet of the apes does not deserve mention, IMO.
I might have gone to see "Dune", but I really don't like Sting, and his shrill "I will kill him!" was in every preview for that movie that I saw. Never read the book(s).
Arthur C. Clarke was a self-aggrandizing blowhard, IMO.
I got to spend several hours with Richard Jordan, who played Duncan Idaho in this movie, when he made the Michael J Fox movie The Secret Of My Success in my office bullding in NY. Very nice man.
He couldn't figure out why he was signed to three movies when his character got killed in the film. I explained what happened to Duncan Idaho in Dune Messiah and Children of Dune (as well as the rest of the novels to that time).
His comment was "Oh, I'm so glad that movie bombed."