I enjoyed the two mini-series of Dune from Sci-Fi. They might not be the best production value, but they stuck well to the story.
"Children of Dune" was a huge improvement over the first miniseries IMHO. I believe it was the very first thing I saw James McAvoy in.