SNL was good during the heyday of Steve Martin and Eddie Murphy, up through the mid-90's with Norm and Sandler / Farley / Rob Schneider (ith...the thapler!)
I remember falling asleep to it in the late 80's and early 90's as a small kid, but I'd always stay up long enough for Weekend Update...