Even to this day, I find First Contact's Special Effects to be the best work in the series, and I'm glad they got a lot of acknowledgement here.
I agree the effects are excellent BUT the one - literally, the one - shot that always bothered me was the explosion of the Borg cube. The model just kinda fades out as its enveloped by sparks and other bits and pieces. Oh well.
