Was Flaherty's Neat Guy also supposed to be Floyd Robertson/Count Floyd, since Floyd had his own alcohol problems? Makes it somehow even better if that was the never-acknowledged intent.
Some of my favorite parts of SCTV were those long-running character bits which don't lend themselves to clips, especially the ebb and flow of the Floyd and Earl Camembert partnership, with Earl starting out as the idiot but Floyd eventually showing up on set drunk for the news. I don't think the clip is online anywhere, but I remember loving a news segment where Earl is interviewing Candy's completely batshit insane Mayor Tommy Shanks that ends with Shanks coming down to the studio to kill him.
It was always great when characters would have various other jobs at the station or turn up in weird places in Mellonville. Stuff like how Dr. Tongue and Bruno are not only guys who churn out awful 3D movies that SCTV can afford to air, but they also live in the city and can show up to volunteer to go into space to knock out a Russian satellite.