This brings me to another long, long-term problem I have with most space-based sci fi. Weapons. I know it's all supposed to be dramatic tension to have someone to shoot at but it's so stupid. I can guarantee the last thing any long distance spacecraft leaving Earth has is a big gun. Of course, in the real world, the chances of bumping into someone else in a spacecraft are infinitessimal but even so. There have been a scant few intelligent secenarios where spaceships aren't armed because if ever there were MAD it's two spaceships shooting at each other.
It was James Blish, in his spindizzy series I think, who observed the greatest difficulty in space battles was getting enemy ships in range. Space is
big. If for some "reason" a starfaring civilization wanted to attack another civilization, it wouldn't mess around with fleets of spaceships impossibly trying to mimic naval battles. They'd just fire a antimatter bombs or gray goo (nanotech replicators,) or redirect asteroids/comets or possibly bioweapons. A perfect anitmissile defense when the enemy missiles might mass mere kilos would be incredibly difficult for practically any tech.
(I know both SG1 and Voyager did the asteroid strike, but both were huge offenders on other counts. SG1 portrayed the go'a'uld as unable to mount security cameras in their ships, as well as being unable to detect radio waves, much less use the information they blabbed in the clear!)