If you didn’t like his Weekend Update bits they were some of his best stuff IMO. You might also look at his guest appearances on Conan O’Brien, he regularly cracked Conan up.
Googling problems certainly helps but you still need enough knowledge to define the problem, Google it, and implement the solution.
I get the impression that a lot of posted solutions are from people who actually spoke to high level tech support for various hardware/software because how else would they know things like what obscure registry key with a very arbitrary name to add?