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.
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.