It may not augur well that we have Miley Cyrus’s dead dog to thank for the latest Beatles cover-version extravaganza.

When Floyd, her favourite pet, was mangled by coyotes last year, the twerker turned to the band she says they had both listened to together – the Flaming Lips. And next month, Cyrus’s collaboration with them on “Lucy in the Sky with Diamonds” is part of a track-by-track remake of Sgt. Pepper’s Lonely Hearts Club Band, by the Lips and collaborators including Moby and My Morning Jacket.

The Cyrus-fronted everything-but-the-kitchen-sink version and full-frontal-nudity video, wherein the song is made over with psychedelic lippy, does not promise a classic, though the album is curiously enjoyable. Meanwhile, an all-star 42-song package of covers of Paul McCartney, The Art of McCartney, finally sees the light of day in November. Excitingly, it features Bob Dylan, Brian Wilson and Smokey Robinson – though it also has, more worryingly, Alice Cooper covering “Eleanor Rigby”.

So what’s the point? “People are like, ‘Why do you do Beatles songs?’,” the Lips’ leader Wayne Coyne has told us, “and I’m like, ‘because people love them’.” Yes we do, which is why it’s so wonderful when the covers go well, and so excruciating when they don’t.

So here are five of the worst and weirdest, then five of the most wonderful. Fab fingers crossed that Floyd’s demise inspires more of the latter.

I Should Have Known Better: Five Flops

Bono, I Am The Walrus (2007)

Bono (Getty) The man whose band has at last found its true calling as spam in your iTunes inbox puts his voice up against John Lennon’s and takes one hell of a beating. This was recorded for the film Across the Universe, which bolts Beatles songs onto a story about... well, who cares? It’s an excuse for the songs. And this one exposes Bono’s misplaced super-confidence in his vocal ability as nakedly as an Irish guitarist’s head with no beanie hat.

Björk, Álfur Út Úr Hól (1977)

Björk (Press photo) On which the 11-year-old future cultural icon sings “Fool on the Hill” in Icelandic, bringing to it all the charm of a teething baby in the seat behind you on a nine-hour flight with no earplugs. It comes from her debut album, which followed a performance on Icelandic radio during which listeners mistakenly believed the volcano Eyjafjallajökull was erupting. Having established that planes weren’t being grounded, the Icelandic public demanded more. And this, in which micro-Björk stamps her foot and bellows for attention over the fade-out, is what they got.

Bing Crosby, Hey Jude (1969)

Bing Crosby (STF/AFP/Getty) Crosby’s bloke-next-door-singing-in-the-bath vocal style doesn’t suit all songs. Frankly, it doesn’t suit all bathrooms, and this is one take that would have been best left behind the smallest room’s door with a note on it saying “I wouldn’t go in there yet”. At the end of the Second World War, US soldiers voted Crosby the man who had done the most for their morale. Luckily the war ended 24 years before he could inflict this on them. The way he replaces the “Na-na-na...” ending with “Pom-pom-pom...” would have called for immediate surrender.

William Shatner, Lucy in the Sky with Diamonds (1968)

Shatner (Getty) It’s Lennon, Jim, but not as we know it. Imagine Star Trek’s James T Kirk on an alien planet, having eaten a strange plant that makes him dance through a purple forest declaiming song lyrics to the sky, and you’ll get an idea of how this boldly goes where no vocalist has gone before. It seems like a joke, but almost certainly wasn’t. One reviewer complained: “Ah cannae take any more, Cap’n!”

Sean Connery, In My Life (2009)

Sean Connery as Bond (Rex Features) “There are playshesh I’ll remember all my life, though shome have changed...” Sir Sean of Devolution speaksh his way over a chamber rendering of the shong (OK, I’ll stop now). The idea is obviously to achieve the kind of impact Johnny Cash had with his emotionally bare last recordings, but is closer to that achieved by Peter Sellers’s hammed-up “A Hard Day’s Night”. Extraordinarily, it was produced by Beatles mentor George Martin – who also produced Sellers!

Magical Mystery Tour: Fab Five

Bugs Bunny and Daffy Duck, Hello Goodbye (1995)

Bugs Bunny and Daffy Duck (Frank Micelotta/ Hulton Archive/Getty) From the album Bugs & Friends Sing the Beatles. Bugs and Daffy argue as to who says what, when, with Bugs getting ever more irritated at Daffy singing the wrong thing: McCartney must kick himself for never having written the lyric “Thometimeth I think he doeth it jutht the thpite me!” So what’s up Doc? Well, it’s great fun, but the characterisations aren’t a patch on Mel Blanc, who died six years earlier.

Wilson Pickett with Duane Allman, Hey Jude (1968)

This contains reputedly Eric Clapton’s favourite guitar solo, from Allman, the man who later contributed that riff to “Layla”. But it is more than matched by Pickett’s throat-shredding performance, which makes McCartney’s screams on the original sound like the early morning yawn of a dyspeptic corgi. And it was never planned: Pickett happened to drop by the legendary Fame Studios in Muscle Shoals while Allman was hanging around looking for gigs, and on a whim the guitarist persuaded him to do it.

Florence and the Machine, Oh! Darling (2009)

Florence from Florence and the Machine (Getty) John Lennon always thought he could have sung McCartney’s Abbey Road track better than its writer, who struggled through take after take, day after day, to get the rough sound he wanted for the vocal. Florence recorded it live at the same studios in 2009, and gave a virtuoso performance that wrings bucketloads of emotion out of it.

Leslie West, Dear Prudence (1976)

Leslie West (Scott Gries Collection/Getty Images Entertainment) Siouxsie fans will choke on their black liquorice allsorts as they read this, but the Banshee’s 1984 sing-along-a-goth pop version of one of Lennon’s favourite own compositions isn’t a patch on this swampy reimagining, from the former Mountain guitarist’s debut solo album. It goes from haunting to searing, courtesy of what were once dubbed “the fattest fingers in rock’n’roll”.

Joe Cocker, With a Little Help From My Friends (1968)

Joe Cocker (VALERY HACHE/AFP/Getty) A contender for best cover version of anything ever. Sheffield’s gravel throat (and master of air guitar) took a song that Lennon and McCartney designed for a limited range – aka “Ringo’s track” on Sgt. Pepper – and turned it into one of pop’s greatest vocal performances. Cocker even changed the time signature from 4/4 to 6/8. While he played air guitar, Led Zep’s Jimmy Page contributed the actual axe-manship. Twenty years later at a Prince’s Trust concert, Cocker sang it with Wet Wet Wet’s blue-eyed soulster Marti Pellow, who must still have nightmares.