Starship troopers in particular has a very curious relationship between movie and book. Where the book manages to glorify the military the movie deliberately chooses an ironic treatment of the characters and plot elements to form the book’s antithesis. The movie is best enjoyed by not trying to fit it into the mold of the book, and vice versa.
I agree. The majority of the reactions here to Foundation seem exactly the way I felt so many years ago to the Starship Troopers movie. I hated seeing it in the theater with a passion and it was because I was one of the people that read and enjoyed the book. Even today when the ST movie is talked about as a cult classic I bristle a little bit - but I can see now it is good as a movie unrelated to the book and a disappointment to a fan.