But that's almost always true, isn't it? There's so often such great potential--whether in a TV show or a movie or a book--and it is so rarely fulfilled. It takes a lot of work, skill, caring about all the little details, and a good pinch of something extra to move anything from "good" or "entertaining" to "extraordinary"--and when you're working on a deadline, it's really hard to manage all four. And even then, there's always, always room for improvement. Nothing is ever perfect, no matter how we wish it were.
I sometimes mourn the SGA that never was and probably never will be, and I sometimes wish that the writing team had a person in charge of continuity of characters and all those fiddly little details, but that doesn't mean I don't enjoy the show for what it is: something a little silly, a lot fun, that sometimes reaches surprising heights and often tries too hard (or not hard enough) and falls down. It's entertainment. And as long as I don't expect it to be anything more than that, I am usually pleasantly surprised instead of disappointed.
This is brought to you by one too many negative reactions to "The Last Man".