For me, Ikeya-Seki was the first contemporary comet of which I was aware (I was 9 years old at the time), and for us in the northern hemisphere, I recall it to be an unviewable bust. I never did see it with my own eyes.
The very first comet I recall seeing was Comet Bennet in 1970. By that time I had a small reflector telescope, and I recall setting it up in the back yard on a cold March or April morning at like 3am and looking at the coma and streaming tail through my little 'scope. Didn't look like much, just a fuzzy patch with no definition near the core, but with my naked eye I could see the tail covering about 30 degrees of the sky. Faint, but rather impressive.
Kohoutek was a bust as well, never even spotted a fuzzy patch in the sky. Hyakutake was the next comet I saw, and I never saw a lot of a tail from it, just an elongated fuzzy patch in the sky. Really not that impressive.
Hale-Bopp was very impressive to me, the near-in tail was very bright and the comet was very clearly visible in the daylight sky. I flew to England while Hale-Bopp was in the northern sky, and I recall out my window seeing the tails (H-B had that cool spiked double tail) rising out of the pale green glow of the aurora borealis as we sped along from the U.S. to England along the great circle route.
I never saw anything but pictures of McNaught, though I understand it was impressive to those in the southern hemisphere.
I'm really hoping that ISON will out-perform Hale-Bopp. All we can do, I suppose is wait. And watch the skies!
-the other Doug