Aphrodite....... I don't think you should be concerned at feeling like this. I often feel that the Stargate viewer/fandom is firmly divided into two camps - those who loved the eerie menace of the alien/historical/anthropological/origins of human race and the way the Stargate itself linked it all into a viable sort of explanation for many of the things that we as human beings on this planet question and are curious about.
However, the other faction, whilst also perhaps being sub-consciously attracted to the same things, have chosen to focus nearly all their attention on the characters. To the extent where the personal desires of the fan have now polarised into a straighforward 'Jack versus Daniel' notion, as witnessed on other threads. Or even RDA versus MS, which is even worse.
And the assumption by fans that these men are some sort of superhuman, wonderful people who don't put a foot wrong or get mad or even do something as simple as take a dump or fight with their wives (or partners) is extraordinary. For all we know, these guys could be the type who beat up their partners (not that I am saying they are, however you cannot make the assumption that someone is a nice person from the only vantage point of a public persona. They are obviously going to try to appear to be nice people in public!). I find this kind of blind hero worship to be banal and pointless. And one of the reasons that Stargate has turned into a soap opera.
And while I agree that the show would just be some sort of documentary on the possibilities without the characters who are necessary for us to relate to all of this, there has been a distressing tendency for the Stargate people, whether it be MGM, RDA & his co producers, writers and or the cast to some lesser degree, to slowly change the original concept of the show to focus almost entirely on these characters, to the detriment of all other storylines.
And this is, I feel, to a great extent why MS decided to leave at this point. He feels it too I think. That the show is slowly becoming obsessed with earth based conspiracies, and they provide us with the Goa'uld loose on earth concept as a sop, which is pretty boring to say the least.
The fact is that we, as a society, are (or should be) well aware that conspiracies exist in abundance on our planet. We know that agencies exist which have their own agenda under the loose protective umbrella of government authorisation and funding. And that these agencies will act out their own agendas whether we like it or not. If anyone doesn't know this, then they need to crawl out of their cave and smell the coffee.
What we don't want is shows constantly reminding us of something we live with day in and day out. Stargate originally took us out of our planet and ourselves, in a way that relates to us here in the present day (unlike Star Trek, Farscape etc who take us into the future and/or fantasy land). It made the notion accessible to us as normal folk. And this is (or was) the great attraction of Stargate..... and it's why so many mourn the passing of the horrific menacing enemy (the Goa'uld), the exploration and adventures on other worlds and the interaction with other races.
Instead all we have now is a sort of X Files spin off.
If this show wishes to go out with a bang instead of a whimper, it needs to stop listening solely to the soap opera, hero worshipping side of the Stargate fandom and start to focus on regaining some of the original concept and thrust of the show.
I certainly have found this season's episodes, so far, to be entirely unmemorable and didn't even stop playing Diablo 2 Expansion Pack to actually watch any of them. The TV just chuntered away to itself in the corner and occasionally I glanced up to check what was happening. And the funny thing was that no matter what point I entered into the episodes I still found them a yawning bore. However, my Paladin is now up to level 84 in Hell!!!
I am disappointed in the focus the show now has of earth based conspiracies. But I am sure that the hero worshippers among us are just loving it simply because their heroes are in it.
Whether it sucks or not.