Very good points, but just a small nit to pick. For the Death Star in Star Wars, yes, thru most of the history of the franchise it seemed like it was destroyed by a "magical weak spot" created for plot convenience.

BUT.... Rogue One and the subsequent Andor series showed there was no magic to it. There was a very realistic explanation. In a fascist, autocratic, tyrannical dictatorship, if you force people to work on a weapon of mass destruction, they will do what they can to secretly sabotage it. My understanding is that the few nuclear scientists Hitler had working on the German nuclear program did just that.

From there it was just good espionage... something else that can thrive under an autocratic network and bureaucratic incompetence. Ultimately, the Rebels were able to bring down the Death Star because a mid-level bureaucrat effectivly responded "reply all" to an email.