Probably too many to mention these days. If you can't wow 'em with a garish can or pump clip design, why not stand out from the crowd with either a ridiculously long name, or 'better' still, a pun.
Had a beer that fitted the former camp here a couple of weeks ago, entitled My Ex Was In A Band And They Had a Hit Called Sheryl Crow. I think there are some Sufjan Stevens songs with shorter titles...
"Breakneck speed we drown ten pints of bitter"
The most stupidly named beer I've had recently is Hello Stephen This Is Clem Fandango, Can You Hear Me? by Fallen Acorn, not a bad beer though.
"Everybody's got to believe in something. I believe I'll have another beer."
-W.C.Fields