I think "The Happiest Days Of Our Lives" segueing into "Another Brick In The Wall Part 2" is the best song on The Wall. I will probably never listen to the CD again--at age *31* I had a weird turnout where I found myself loving The Final Cut (having never really bothered to hear it before) and The Wall, but only because I rewatched the movie, which I think is really good. It was weird to suddenly find Roger Waters' two most personal, self-pitying albums emotionally resonant after years of thinking that Roger was a dick and that The Wall, while still decent musically, was kind of an album for pseudo-intellectual teenagers, which was about how old I would have been when I first heard it.
"Welcome To The Machine" also is better to me now--I used to find it cold and boring, but set to that creepy bit of Gerald Scarfe animation made back in the 70s, it's actually better.
Dream Theater ripped off "Comfortably Numb"? Ugh, do I want to go look through their catalogue to find out when they did that? Their godawful 20 minute ridiculous epic "The Count Of Tuscany" starts with John Petrucci doing a very dull, very obvious ripoff of the cold intro to "Shine On You Crazy Diamond." Otherwise, you're probably just thinking of "Silent Lucidity," which was the most played video on MTV in 1991 in spite of all the grunge breakthrough that year, the fact of which pops up EVERY F***ING TIME someone wants to say "grunge didn't kill hair metal!"