Personally I find Lynch's Dune a source of ceaseless fascination. On the one hand I can't help but have a soft spot for it since it was my introduction to Dune and lead me to reading all the original novels. But on the other I recognise that in the final analysis it ultimately failed.
I forgot to mention (no, the Padishah Emperor Shaddam IV is not my father

) that
The Making of Dune, by Ed Naha, is a terrific book detailing the behind-the-scenes account of the Lynch movie. It's amazing how they managed to overcome some of the insane obstacles they encountered to turn out a movie. From casting problems to finding a location with enough desert to dealing with actors getting sick from the local food/water, not to mention having to wear black rubber stillsuits in the middle of a desert, to the language barriers (English, Spanish, Italian, and one other that escapes my memory at the moment)... there were a lot of problems to deal with.
I am aware of it and have heard good things about it, but the last time I went looking for it on eBay or Amazon people were asking silly money for it. :/
Anyway, as I went into at some length in a similar thread some months back, probably the filmed medium best suited for a "good" adaptation of Dune is probably a HBO style mini-series running from about 8 to 12 episodes a season, with the first book broken up into three seasons, DM one all of it's own, CoD two, skip over GEoD/weave the gist of it into the subsequent books and perhaps just one each for HoD & CHoD.
You can't skip
God Emperor of Dune. Yes, I know there's not a lot of real action except at the beginning, the end, and a couple of scenes in the middle. Most of it is Leto rambling and the other characters either adoring him, hating him, or being confused by him. But it does explain why the Bene Gesserit in the subsequent books call him the Tyrant and consider Jessica a Bene Gesserit traitor. It's also important to have Duncan's point of view, since he serves as the audience's "spokesperson" who wakes up to find that 3000 years has passed (up to then no Duncan Idaho ghola has remembered any other existence than that of his original pre-death life) and everything he knew is gone and he has to fit in with this crazy new society that doesn't make the slightest bit of sense. Plus, keep in mind that there's 1500 years between God Emperor and Heretics.
There would have to be some tweaking of the end of
Chapterhouse: Dune, since it ends on a cliffhanger.
Like I said, I went into it with some more depth in
this thread, but my general notion would be to weave the GeoD material into the narrative of Heratics & Chapterhouse. There is indeed important stuff in there, but I think it need not be introduced in a linear fashion.
IMO the narrative of GEoD is just incompatible with a direct adaptation and any attempt to re-interpret the material into something more tolerable would I think be ultimately pointless, if not downright counter productive. Personally, I like the idea of going from the end of CoD straight into Heretics. Hell, I might even say it'd be a great hook to put in the final episode of the CoD season. To go from Leto declaring himself God Emperor, right into that little historical presentation scene at the beginning Heratics (?) would certainly get an audience's attention. I'm thinking shades of
'Deconstruction of Falling Stars' meets the
"shape of things to come" stinger from Caprica.
Besides, as luck would have it Other Memory and Leto's little prescient messages he left behind gives a totally valid in-universe mechanism for flashabacks. With that in mind, Leto could very much be a presence for both Duncan and Odrade.
As for Chapterhouse's ending; I'd pretty much leave it as is. Ambiguous and open to interpretation with humanity's future a mystery. Perhaps I'd leave out the bit about the capsule with the DNA samples of Paul, Jessica etc., but that's all really.
Speaking of Wensicia, did you know that she's supposed to be younger than Irulan? Susan Sarandon is definitely not younger than Julie Cox...
IIRC Sarandon was a fan and actively lobbied for the part (or at least "A" part.) While at first it seems at odds with the idea that Irulan would be next in line, it's not unheard of for a monarch to specify a younger descendent heir designate, usually if the older sibling is unsuitable or simply ill favoured (indeed the Baron intended exactly that for Feyd over Rabban, the elder nephew.)
In the case of Wessica it works quite well into her character if she's bitter over being cheated out of her birthright (most likely at the behest of the BG) and feels her claim to the throne is stronger. It's a change, yes but I think a worthwhile one in order to get such a good actress in the role.
Anybody interested in the possibilities of a great Dune movie NEEDS to watch Jodorowsky's Dune. This is an absolutely fascinating documentary about a pre-Star Wars attempt to get an epic version of Dune off the ground, that had it come to fruition, would have changed the course of cinematic history.
The film looks as though it would have been incredible, and is packed with amazing ideas about how they would have brought it to life, but even more interesting is to see the depth of impact an unmade film has had upon Sci-Fi since. It's designs and ideas are strewn throughout subsequent films like Star Wars, Alien & Blade Runner.
I've seen artists' conceptions of that, and they're stomach-turning. That, plus the rumor that there was to be a scene where Paul and Jessica commit incest, makes me glad this version never got made.
As previously indicated, I'm with
Timewalker on this one. Jodorowsky's take on Dune would have been horrendous as a Dune adaptation. That aside, despite all of Jodorowsky's ambitions and grand proclamations, his approach had all the hallmarks of a spectacular flop.
Pingfah is correct in that it indeed a fascinating documentary and worth watching for anyone interested in the history of cinema. I just happen to think that what we got in it's stead was far better than what I think we would have gotten had Jodorowsky gotten his way.
Don't get be wrong, the artwork was visionary and the pre-production team was a very talented and eclectic group of individuals...but I think the weak point would have been the script and the direction; needless to say, for a film that's kind fo a biggie.

Of course we'll never knew for sure, but for me a science fiction film which features a hot, arid desert planet that is also a rogue body with no star to orbit...clearly isn't written by someone with even the slightest notion of science. The less said about conception though drops of blood and Paul's minding possessing all of humanity the better! Yikes.
For all it's "out there" concepts, Herbert's work has always been grounded in a solid foundation of science. Indeed, IIRC the main inspiration for Dune int he first instance was an ecological article in a science periodical about holding back expanding desert dunes with the planting of poverty grass.