Erkine, I know what you mean. Uriah Heap for example. Uriah Heap of what? Feces?

Although Judas Priest is a petty decent name.

More good ones:
The Kinks
The Talking Heads
The Vaselines
The Breeders

Bad ones:
Any band named after a city or state, such as Boston or Kansas. However, a name like The New York Dolls seems to work.