The Children of Dune
miniseries is the best of both worlds. It's got the plot-faithfulness (and some of the actors) from the first mini, but much better production values.
And, as has been mentioned, the soundtrack is so good that it's been using in dozens of unrelated ads and movie trailers. One of the Star Trek 09 trailers even used it.
Among the actors who changed between the Dune mini and the CoD mini, I liked both Jessicas for different reasons, Duncan was much better in CoD (although he didn't have much of a role in the first one), and I'm not sure they got Stilgar right *either* time but I liked the Dune guy a bit better.
No offense to Patrick Stewart, of course, but P. H. Moriarty is easily the better Gurney Halleck.