I really hated the movie. I preferred the Mini Series from 2000 from SciFi. The special effects certainly didn't age well but it told the story much better.
It would take at least a Hobbit level of production and length of time. I don't ever see that happening. The book is just to large. It would be like movies for Asimov's Foundation Series. (Though the Caves of Steel would be awesome!!!)