I'm not going to get in the debate over where this album fits in the "officially sanctioned" order of Yes's albums. Each and every one of us puts that in a different order - heck, I put them in a drastically different order now than I did 20 years ago. And that'll probably change in another 20 years, God willing.
My brother introduced me to Yes in the late 70's - Close to the Edge in its entirety and Roundabout were far and away my favorites then ('course, they were his, too -- hmmm). In '82, in the midst of my punk & new wave phase, I bought Fragile on a whim. Within 3 weeks, I had EVERYTHING they'd ever released. WOW!! It was all fantastic and I couldn't get enough of them. Thankfully, I was single and in the USAF so I could blow every $$ and still have room&board :-)
Years went by, I lost most of my album collection in the late 80s, and I didn't listen to any Yes until a year ago, when I started buying the CDs (CTTE first). As I build my collection again, I find that TFTO is now far and away my favorite. If it were possible to wear out a CD, it'd be trashed after only 4 months! (BTW, Fragile, Relayer, and Tormato have all taken a precipitous slide in my ordering - some good but much not good).
I am absolutely astonished how good this is. As many others have pointed out, its long songs do demand much of you to listen carefully throughout. But I find that the best part. My life is so busy these days (mid-40s, mid-career, mid-kids, mid-life). To take the time and sit quietly throughout this whole album is a beautiful break in my life. I find much of it very uplifting and re-energizing, and very little of it that is not fascinating. I play it over and over at work (thank goodness for wireless headphones and relaxed management!).
Give it a good listen - give it a 100 good listens - I think it's worth the effort.