Despite the many people crowing over the pricey attraction’s premature demise, it offered an unforgettable, once-in-a-lifetime experience, argues Graham E Hancock