I think the Pantani final time trial from the year he won the tour is right up there for me. Seeing someone excel at something that isn't ther speciality is just a little more out of the ordinary...
Also, boringly I really enjoyed all 7 years of Armstrong and was sad to see him retire.
AC