Futurama by far. *nods* Kinda stands out in the category though, considering it never took itself seriously and all the rest were pretty serious.
'sides. I can think of happier sci-fi shows that were canceled that I loved. Dr. Who for one.
Then again I'm pretty sure that show more than ran its course...and really so did Star Trek.