Magnification is pretty good. The joke of course is that Wakeman left (again) and they needed a whole orchestra to replace him. But the band insists that the music was written to allow space for where the orchestra would fill things in. Connecting the dots, they're kinda the same thing. Kinda. It sounds great, and there are some good songs, but overall I don't listen to it much. A lot of the songs are on the mediocre side, and overall the album is very homogeneous because of the same instrumentation on every song, so I find myself getting bored halfway through.
I listened to Fly From Here again just the other night, and I always forget that this is not Trevor Horn on lead vocals. Benoit sounds a lot like him to my ears, and the opening suite being an expansion of a Drama-era song helped with the illusion. It's been referred to as Drama II, and rightfully so. Overall I like it. Try to find the import version with the expanded version of "Hour of Need". With the instrumental intro and outro, it becomes its own mini-suite and pushes up the prog factor.
I cannot get into Heaven and Earth. Such high hopes for this album, and this lineup, and the results are just so, so bland. Most albums benefit from a nice mix of heavy and lighter songs, varying moods, etc. This one is all light and mellow. Even when you can feel them trying to get heavy, it never really does. Such a boring, disappointing album. My least favorite Yes album of all.
I don't have Symphonic Live, but I have the live Blu-ray, and if it's the same performance, it's great. Rather than the orchestra replacing the keys, it's used to augment the overall sound, with some pretty impressive results. I honestly didn't think it would work as well as it does, adding orchestra to killer songs like "The Gates of Delirium" and "Close to the Edge" but it works well. And after listening to "And You And I" with mellotron strings for 40 years, hearing those sweeping, soaring lines played by a real orchestra actually brought tears to my eyes. It's really beautiful. Definitely get this one.
Progeny is pretty cool, but in some ways it's more of an interesting look into how things change over the course of a tour. The same seven-song setlist for each show, so you have to really listen a lot to catch the differences from night to night, but they're there. But it takes a lot of listening, and a lot of money (14-disc set!) and may or may not be worth it to some.
I haven't heard the others. I'm actually not that big into live Yes. Their studio stuff is just so perfect, that while it's impressive how well they pull it off live, I always find myself reaching for the studio albums when I need my Yes fix.