I'm pretty sure the Sagrada Familia could have been finished sooner if more money had been thrown at it, but in a sense, I also think such a prolonged construction process is itself a work of art. We are often in too much of a hurry, leading us to cut corners.
I don't think "cutting corners" as a negative -- it's realistic, if you want to ship. Nobody who said "let's build a new church here" lived to see its completion. It's awesome to see, however impractical for 99% of solutions, the occasions when a "screw time and budget -- this thing is going to be perfect" approach is followed through.
The Long Now Foundation also thinks about this kind of thing.
(Though walking up and down the spires in the earlier stages was much more fun than the lift, if a little scary.)
While it certainly doesn't have the duration of this construction: After watching the LOTR making of, I'd say projects like this are the closest equivalent to the construction of a medieval cathedral, w.r.t. scope and scale, attention of detail, the imagination of a whole, complex interwoven result that conveys a planned experience.
This is in fact the reason why it is used as a cover of CTM (in many ways an awesome SICP sequel):
Started in 1892, one of the largest cathedrals, as yet unfinished.
Most of the cathedrals in the U.S. were "tossed up" after a few years of construction. (One of the rare counter examples is the National Cathedral in Washington D.C., however it's not Catholic.)
If we start any current projects in the world that we know will take generations to finish:
* I won't see the end of them
* I'm not sure there's the will to do it
The idea of something like a generation ship, or interstellar colony ships is something far away from what we seem to be able to do today, but I like to think that projects like cathedrals are about as close to what those kinds of things might be like.