If it really _were_ made however, yeah, it could _only_ have be a disappointment in comparison to what the documentary about it suggests.
Jodorowsky's version of Dune is perhaps the greatest film that was never made and, ironically, it is better this way.
He spent an entire summer filming the Strugatskys' original screenplay, based on their masterpiece Roadside Picnic. But he was using a type of American Kodak film stock that was found to be out of date; he tried several times to confirm the problem with the Soviet processing lab, but they were unfamiliar with the stock, and only by the time he was done shooting did they realize that the footage was in fact unusable.
At this point Tarkovsky had used too much money, and had no choice but to go back to the Soviet film board to negotiate a new financing deal. At the same time, he was deeply unhappy with what he'd filmed so far (he had also fired his cinematographer), and was desperate to start over fresh. Helped by the Strugatskys, he developed a new, miminalistic framework for the film that eliminated most of the scifi trappings of the novel, and he reshot the film almost without a script. (The whole story of Stalker is much more complicated, of course. I recommend the book "The Films of Andrei Tarkovsky: A Visual Fugue", by Johnson and Petrie, for more information.)
I don't know what happened to the damaged footage, but I guess it must have been destroyed. We'll never know what it was like. I don't think anyone except a handful of people have seen the footage, and they are all dead.
To my taste, self-acknowledged silly extravaganza is always better than something silly, made with the intent of being serious.
We also have to remember that this was before Star Wars and Alien. Most scifi at the time was, with some honourable exceptions (2001: A Space Odyssey, Silent Running, The Andromeda Strain, Solaris), pretty silly, childish, often campy stuff: The Black Hole, Buck Rogers, Moonraker. Pulp origins aside, Star Wars introduces a level of violence, maturity and realism to the genre that stood out at the time, and closer to that of contemporary adult 1970s productions like Apocalypse Now, Easy Rider and so on.
For all the considerable talent involved in the Dune adaptation, it's quite possible — and this eases the pain over the loss of the project a bit — that it would have been closer in tone to something like Zardoz or Flash Gordon, i.e. a big, colourful, but ultimately also a bit silly extravaganza. Even O'Bannon's Alien script was also pretty pulpy and silly until Ridley Scott, David Giler and Walter Hill hammered it into shape.