Getting back to the Season 3, Allegiance while not a great episode, it did look really great. The effects shots of the Enterprise wow! Especially the one where she flys above the camera and the shot is looking up toward the bottom of the ship as it enters the system.
That's one of my favorite shots from S3. The team did a great job compositing that one