I thought this film was beautifully shot in classic Stargate SG-1 style, I think the only comparison was the season finale of Season 7 regarding Special effects. The comedy and the banter among the characters kept your interest and the Special effects were simply amazing.
Overall I thought it could have been longer, and felt it should have been, I think the Directors Cut will be a must buy.
I feel this will be an enjoyable experience for Stargate fans.
I must warn you that some characters tend to swear somewhat in this film. I would watch this before leaving your children watch it to make sure it is ok.