Dave Paterson -- funny guy.
SNL skit -- for the most part, not funny.
Fred Armisen impression -- physically, quite good.
If anything, I suspect Paterson was offended as much by the fact that they portrayed him as an unfunny guy. His wit and self-deprecating humor are great.
Making him out to be bumbling and incompetent is something no politician would want. Using bad stereotypes of blind people just makes it worse. How funny would a skit of Obama be if the only humor they used was bad stereotypes of black people to make him incompetent because all black people are incompetent? Or a Palin skit that only made fun of the fact that she's a woman, using bad stereotypes showing that all women are incompetent?
One judge of competence is approval ratings. For comparison, Spitzer in Jan 07 started out with around a 60% approval rating and in Feb 08 (before his scandal), it had nose-dived to around 35%. When Paterson stepped in, his approval ratings started out around 35% with just as many not knowing him well enough to form an opinion one way or another. It's been steadily improving and is around 60% now (with around 10% still not knowing him well enough to have an opinion).