YMMV / Star Trek Enterprise S 03 E 08 Twilight

• Special Effect Failure: They really put minimal effort into making the cast look older. Connor Trinneer gets a grey streak or two in his hair and Linda Park just gets a cheap wig thrown on her.
• Visual Effects of Awesome: The teaser, of course, which shows the fucking apocalypse in tremendous detail. Roll titles! Credit where it's due, it's one of the coolest teasers in the franchise. (And it was only made because the SFX people had nothing better to do.)

---