I've come across a few good band names over the years. I always liked the names of bands like "The Funkin' Barstewards" and "Telephone Bill and the Smooth Operators". Also came across bands called "The Muff Divers" (Muff is a town in County Donegal) and "Fiveskin".

On a similar theme (at the risk of threadcreep) some song titles can be quite funny. Two that come to mind are a song about a motor-bike loving roadie called "The Packer of the Leads" and a blues song about a wayward girl-friend called "My sugar has turned to Alcohol"