"I think it's a TV faux pas to think that stable (not the best tern here but go with me) relationships would bore the viewer."

Oh, I agree. Big mistake. I LOVE seeing an honest-to-goodness happy couple on screen. Look at Zoe/Wash on Firefly. Love that couple. Notice, though, that it's the female 2IC who's allowed the happy relationship while the male lead who, well, I don't know how to describe Mal.

It would have been very nice to have Jack married and have SG1 be friends. All of them. :)