Well, if all he used was the SR plugin with no additional enhancements, then it would look like shit. Precisely because that's how the GOUT looks anyway. What's interesting is DrDre has done (essentially) the same thing that I did with SD footage I wanted to upscale, and YouToo and others as well. And that is to find the right method to enhance the detail in the source, to make it look as good as possible. He has found quite a good way to filter out the noise present to prevent it from being enhanced to the same degree as the other detail.
It certainly isn't SR on its own that brings the source to life - its his Avisynth script that implements SR in his own uniquely designed way.