I think the show’s prime was from ‘92 to ‘97, the years after it declined slowly but after the millenium, the show became unwatchable, IMHO.
For me, it was the death of Phil Hartman, whenever that was. It went from a natural, sarcastic, but upbeat outlook to a cynical, pessemistic show. It didn’t take me long to stop watching.