Well, no, not really. See below.

>Trek writers deciding they had written a
>villain that was too mighty and suddenly pulling an endless series of
>technobabble macguffins out of their nether regions rather ruined
>that.

I think you've got the cart before the horse here. It wasn't that the writers decided to do that; more that they discovered that they'd created a threat so powerful it could only be defeated by authorial cheating. The concept ruined itself by being unworkable from first principles. The Borg were hopelessly flawed out-of-story from eight o'clock day one because such pains were taken to establish that they were without exploitable flaw in-story; any road to showing the heroes defeating them at that point automatically became a case of "oh, except this. And this. And also this and this other thing."

A monster that has an automatic counter to everything the adventurers might attempt can, by definition, only be defeated if the DM decides it will be, which is never going to be anything other than obvious and unsatisfactory.

--G.
-><-
Benjamin D. Hutchins, Co-Founder, Editor-in-Chief, & Forum Mod
Eyrie Productions, Unlimited http://www.eyrie-productions.com/
zgryphon at that email service Google has
Ceterum censeo Carthaginem esse delendam.