The best movie based on a book I know is the Princess Bride, and it is the only example I know of where the movie really surpasses the book.
Other than that there are a few example of good movies and good books, though usually the movie is good only if it finds its own voice. Stand by me was a great movie, Frankenstein (I like the Mel Brooks rendition, but of course it's a parody).
