The only comet that somewhat measured up during my lifetime was Hale-Bopp in 1997 - the one that caused that Heaven's Gate cult to commit mass-suicide. At least that one you could spot with the naked eye and while not exactly spectacular, it was something you could look up in the sky and actually see without having to rig up a telescope.
Comets pretty much suck wind. I did like Bill Haley and his Comets however.