Stargate SG1/Atlantis seemed to handle this better by either:
1. Incorporate the new technology and
1a. Either have good understanding of it but doesn't tip the balance of power significantly
1b. Or only have partial understanding of it and not be able to use it at full potential
2. Continue researching it because it only worked once
3. Or Discontinue or shelve use of it because it was too dangerous or had side effects that they were unable to overcome.
4. Kept it from public knowledge and left it only for select units to use.
Too bad Star Trek didn't take 1 or 2 lines of dialogue to hand wave the super tech away or incorporate it better rather than hold onto the status quo.