DO NOT IGNORE THE PREVIOUS POST. Just because I wrote this one so quickly.

bands with very strange names

Stone Temple Pilots
Frou Frou
Butthole Surfers

bands with Rather Cool names

The Pixies
Queen
Weather Report
The Beatles
Manic Street Preachers
Sonic Youth
Sly and the Family Stone

bands with names that probably sounded like a good idea at the time

The Red Hot Chili Peppers
Franz Ferdinand
Guns N Roses
Jamiroquai
Slayer
Radiohead
U2
Velvet Revolver
Yes