Re: Wikipedia lists all the movies btw
Charles Rocket is remembered, if at all, for playing the bad guy in Dumb & Dumber, which was the same year as It's Pat--he's an SNL alum, but I've never once seen an actual clip of him doing Weekend Update. He was hyped as the new Chevy Chase in 1980, which was the first year after Lorne Michaels left for awhile, and which is almost universally considered the worst year of the show. At the end of the season he said the word "f***" on the air, the clips of which you can still go look up. He committed suicide some years ago by slashing his own throat, IIRC.
A Night At The Roxbury still has some fans, but it's because they like to quote a really stupid line ("EMILIOOOOOOOO!") The sketch was very funny the first time they did it around 1996 or so, with Jim Carrey playing the third guy, after that it was pretty much diminishing returns.