This review is primarily going to discuss the physical box set rather than the show. If you want to know more about the show, I suggest you check out the individual season reviews, of which there are plenty here on Amazon.
In terms of the physical product, it's going to depend what you want out of an SG1 box set. If you're simply looking for the cheapest way to get all 10 seasons and the 2 movies, this is currently the best deal around. It works out at about £14 per season, which is very reasonable considering the individual seasons cost £60+ when they were first released; you also get the two SG1 movies for free which is never a bad thing.
However, if you're looking for an all singing, all dancing, limited edition box set, this probably isn't for you. Whilst there's nothing distinctly wrong with the box itself, I think they could have perhaps made a bigger deal of presenting the set with a little more flair. The box itself doesn't have a back/front (depending which way you look at it), so would be very easy to tip the individual seasons all over the floor if you pick it up awkwardly, but it also means you can get at each of the seasons without having to take the whole thing off your shelf. Whether the trade off is a good or bad thing is up to the individual. The seasons themselves are presented in fairly typical, plastic 6 disc containers. The discs are secure (though there was one loose disc), so I don't foresee any major problems in the future.
I own a lot of box sets, and to be honest I'm a little torn about this set. On one hand, it's a little too basic for my tastes, which is somewhat disappointing; I would have liked something a bit flashier to put on my shelf. However, I know from first hand experience that when it comes to actually watching the DVDs, having a box set that lets you extract the discs with as little fuss as possible is always a god send.
This set delivers everything it promises (namely 10 seasons of SG1), so it's really down to whether you like the presentation.