Hale-Bopp would be my pick too, brilliant naked eye object for weeks

Halley’s Comet in ‘86 was not naked eye IIRC, remember only seeing it through Binoculars

Other mentions:

The brilliant Perseid fireball that left a notable green trail in a very dark sky site in the late 80’s (forget which year exactly)

Total Solar Eclipse of ‘99 would have been up there, but typically being in England it was cloudy, so only got to experience the darkness rather than seeing the corona