Once in a lifetime? Those 2 comets in the 90s were quite bright and visible even from cities. Magnitude 4 is on the “meh” scale.
Hayukataki. Hale Bopp. Yep. We were pretty lucky to see those. And that one last year or was it the year before was quite nice. It was overcast and cloudy the while time Haley’s was here but who knows, maybe I’ll get to see it next time.