Cleopatra 2525 comes to mind along with Andromeda for TV shows. For movies, the recent spate of bad straight to Sci-Fi Channel films like Dragon Storm, Sabretooth, and Caved In comes to mind.
Seaquest constantly went back and forth between good shows and flat-out stupid shows. My favorite "bad" episode was the one with the prehistoric 200 foot long crocodile. Out of nowhere, Lucas (the 16 year old computer whiz kid) became this prehistoric dinosaur expert. Instead of killing the gigantic croc, they decided to save it and put it back on ice. Unfortunately, the did this by drugging it, towing it to an ice flow, then shooting torpedoes at an iceberg causing the croc to be seemingly crushed by giant chunks of ice.