@Faket Was 100% worth it for me.. didnt hijack the universe but added to it (something a lot of newer revivals fail to do sadly), the actors were veteran well known scifi actors so the acting was good.. the effects were a bit low budget but bearable (and there is an enhanced version supposedly with better GFX). And, well its stargate, so ill take it!
My only criticism was the ending, I thought it could have had a better ending, didnt ruin it or anything but there was one aspect of the ending I would have changed.
Overall I'd say if your a stargate fan give it a go.