We were spoiled by Star Trek: From series to movies was two decades of improvements in production and FX quality, and an equally large delta in budget.
Whereas, one of this movies many favorable attributes is the homeliness: they aren’t wearing sleek new $250,000 uniforms, there are no new team members, the friends/aliens/enemy are cast recalls, the SGC hasn’t been redesigned and renovated. Several of the cooler ‘effects’ sequences are actually filmed using real US Mil. hardware.
This is classic Stargate: Aliens have snakes in their heads or bellies, humans fly aircraft, nobody gets beamed and there are explosions.
But you definitely need to start by watching the extras so that your expectations aren’t set by the hype and anti-hype. Get yourself back into that mindset you had midway thru season 4, 5, 6, 7 or 8; dial back to a Friday evening with soda, snacks and the sofa, pop the disk in and watch … and you’ll be well pleased :)