Also strongly recommend binging the first season in particular; they did a very good job of conveying the feeling of humans blundering about not really knowing what they are doing in the big new universe, and it really comes across when watched relatively quickly on top of each other. It is reasonable that as the seasons rolled on and they got their bearings this toned down in favor of other plot lines, but I think this is one of the more unusual tones in sci fi that a show managed to successfully convey. Enterprise really whiffed on this, in my opinion. (They should have had a first season more like SG-1's first season and saved the "temporal cold war" plot arc for later. Or perhaps even not at all. That would have been OK too. There are a couple of episodes that convey this sense but not enough to hold the tone IMHO.)
Also, if you are starting out, I kinda recommend the Stargate movie first... it isn't strictly speaking necessary but it will contextualize some things, even though it's only sorta half in the continuity with SG-1. But I will say that if you kinda dislike it, continue on to SG-1 anyhow. In my opinion it's a big step up in a lot of ways.