Watch it for sure, especially if you can get the DVDs. Sometimes you can find them on sale... I bought the last 4 seasons for $20 a year from Buy More... er, I mean Best Buy. ;-)
The thing I like most is that it's a complete story that builds through the whole series. Unlike Trek, where everything resets to the status quo at the end of the episode. ;-) Stargate SG-1 is the same way... they learn or "borrow" new tech and use it, rather than make up some technobabble explaining why it won't work or some such excuse.