@sinbad You can still clearly see the limits, and that's the "retro" part - grappling with those.
SNES/MegaDrive had less CPU power, but more hardware, and for some of those games I think they got to "good enough" graphics to lose some of that "retro" feel. But I am absolutely open to debate on this.
Of course, as soon as you want to go 3D it all looks terrible again. 3D stays "retro" all the way up to the N64/Saturn/PS1 - all of which look eye-scorchingly bad in their own ways.