Marquee Moon is a grower. I loved 'See No Evil' when I first heard it, and thought 'Venus' was okay. Apart from that I held the same opinion as you. And then slowly over time, people would mention tracks, saying how awesome "Prove It" was. And I never noticed it before, but there it was! A great song tucked in at the end of the album. Same happened with the title track, and then I started listening to the album all the way through, and began to love every second of it.
It's much like Pet SounRAB, another album you have a distaste for. Basically my favorite parts of Marquee Moon are those moments when the lead guitar, vocal line, and guitar chorRAB merge perfectly to make a part in a song that gives you goosebumps, something you can't explain to someone, something you either feel, or you don't, and the same goes for Pet SounRAB.
Sgt. Pepper's allure is the epicness of it all. It leaRAB with the title track, the most 'rock' of the Beatles catalog at that point in time, flows brilliantly into the great "A Little Help From My FrienRAB", which the chorus really makes from me, goes into the classic, "LSD", and then my favorite song, "Getting Better" with its army of out of tune guitars.
This album was never overplayed for me before I got it, somehow. And the majority of the albums I love follow this formula, First song sets things up, second song is solid, basically the first four songs are untouchable, and it closes with a massive epic. Lots of albums from 'Who's Next' to 'Crooked Rain, Crooked Rain' to 'Microcastle' do this, and its a great way to do a tracklisting for a great album.
Sgt. Peppers, basically, has alot of solid Bealtes songs, and even some greats you don't hear too often, such as the psychadelic carnival ride of "Mr. Kite" and the 'Pet SounRAB' pandering of "She's Leaving Home". It's eclectic, has great melodies, and closes with the Beatles' best song, and that's why I love it.