SuperResolution works very very well with downscaled video - in particular reduced by 2 or 4 times; take a look at Infognition comparison here; it's difficult to achieve similar results without using a temporal upscaler.
But with "real" SD material, some other upscale method, combined somehow, maybe, *could* be really similar, and occasionally spot some details where SR was not able to find - your mileage may vary! (^^,)
I don't know if sharpening, antialiasing, antiringing etc. filters could retrieve details more and better than SuperResolution alone; what I did is to use them in conjuction with SR - in a long chain - and the results *may* extract some fine details, while losing others... so, to whom has not understand this (I was one of them few months ago), there is NO filter(s) in the world which could completely restore image details from a low resolution source, to be equal to an high resolution version of the same - this is an evident assumption, but I think is good to repeat here.
Stated that, there are different methods to try to restore as much details as possible, and SuperResolution is one of them; is it the best? I don't know, because I've seen on the net WONDERFUL methods - sadly, they have so highly technical detail, that's difficult, if not possible, to find a way to use them practically - I use Avisynth like DrDre, and it will be great if we could "play" with these upsizing methods, don't you think, DrDre?
Well, I could add my own experience; I "discovered" another method to extract details, and, even if it doens't work everytime - you could read in the article why - when it works, it make wonders: the PaNup™ technique - note the ™, it's my "trademarked" upscale technique, open source, but cite the font! (^^,)
So, I used them in conjunction, and the result is astonishing! Don't believe me - again, as Mulder was used to say, "trust no 1", but take your conclusions after watching the comparisons:
PAL LD - Bicubic Vs NTSC LD - Bicubic:
http://screenshotcomparison.com/comparison/125555
PAL LD - Bicubic Vs LD MagicSR:
http://screenshotcomparison.com/comparison/125557
NTSC LD - Bicubic Vs LD MagicSR:
http://screenshotcomparison.com/comparison/125558
Next step: obtaining a perfect CSI 16x zoom in with total detail reconstruction, possibly taking them from the reflection on the pupil of a flying hummingbird - we (me and DrDre) are working on it, we'll find the solution in, let's say, two or hundred years - our clones will continue to job for us! (^^/) (^^/) (^^/)