I updated AE via the cloud but I still do not see the video upscaling effect.
What version did you update to?
See if this video helps.
Give us more detail of how you're looking and what version you're using.
Effects --> Distort
Of course only in AE CC 12.2, not CS 6 or any of the previous CC versions.
Retrieving data ...