For me, has to be Stargate (on Showtime). Not as good as the movie, but most enjoyable. Also liked Earth 2 when it was on. And of course, ST:NG and DS9.
My fave in the 'it's so stupid, it's funny' is LEXX.
------------------
The day we stop learning is the day we start dying!(c)
Co-Owner/Operator of the Evil Petting Zoo and devout member of the HADB clan.
Commander of the Dragon Fleet, IW Peacekeeping Force
Sublime Sister of the Illuminati - may the Light shine forever!
Mage extraordinair, Pin-Up Girl for the OLD-COOTS
Magey-Wagey: performer in the Nekked Dancing Trio of the ORT.
Occasional minion to Gwhanos the Fluffy
Hopeless Romantic *sigh*