Yeah, I never really cared for him on SNL. The only times I found him funny was when he'd break character to laugh at Will Ferrell. But he's definitely found his niche on TTS.
I also didn't care for him on SNL; just never thought he was very funny. I too have completely turned around and now think his talent is just great. Both the Neil Young and Morrison impersonations are killer, and he really has improved the show. Great hire for The Tonight Show.
Edited to say I'm like '73 below and a Young and CSNY fan. Yes, he's a head case, but talented and I very much like his and CSNY's music. When he discusses issues, well, that's another story.
BG