I'm with you. I feel like Horizons gets way more hype than it deserves. I'm sure it was a technical marvel and was certainly ambitious, but I don't really recall it being that fantastic of an experience; in fact, the only thing that really left an impression on me was the choose your own ending.
IMHO, JII and WoM were better rides and bigger losses for classic Epcot (though at least TT is a quality replacement, albeit very different).
For me what was so cool about it was the concepts of living underwater, the futuristic luxury apartment with the huge windows and the cool city in the background (I'm a huge fan of the retro futuristic apartment scene at the end of Space Mountain as well), the scene with the desert farming.. All that stuff just seemed so far-out to me as a kid. But then again my favorite things about sci-fi shows were the actual sets and technologies. So I guess I just felt at home when I rode horizons. As a kid, it made me feel like I was actually at a set for something akin to ST TNG etc..
I agree with you about JII as well. JII was amazing! Dreamfinder and his ship also blew my mind! Talk about imagination. Also one thing that was so important to that attraction to me was the relationship between Figment and Dreamfinder. That relationship was crucial to the story and theme of the attraction. And also the rainbow corridor was amazing! I remember being upstairs at Imagination and looking up at the glass pyramid ceiling feeling inspired like never before.
And that's what missing from today's Epcot. Back then it was inspiring, exciting, educational and fun. It was like the science fair at elementary school (the funnest day of the year except for field day and maybe the book fair) combined with Disney magic, technologies, excitement, wonder and beautiful architecture/landscaping. I know when you're a kid everything seems bigger to you, and maybe that was part of it as well.
No theme park has ever come close to making me feel the way EPCOT did. Now days when I go to FW, its all nostalgia. And its sad.
But I do still love Spaceship Earth and the Land Pavilion. To me, those are timeless. I hope they remain forever. The only things I'd like to see happen to those 2 attractions are:
Update the scene in Living with the Land with the large screens to newer HD video.
A new ending for Spaceship Earth.