Another one I watch from time to time is "Stargate" (the movie). Plot makes absolutely no sense at all, regardless of the technological angle, until the nimrods get to the planet.
Saw this a while back and ... it's forgettable. I never watched the series either.