At least those two episodes, Year of Hell and Equinox, have antagonists that are fairly interesting and well played by two very good actors. They at least have that going for them, which put them ahead of most other episodes of the series, unfortunately.
Agree about Year of Hell. Ransom in Equinox being converted by Seven's beauty (and Imaginary Seven dialogue) is abysmally bad writing.
When it comes to the technology, you're looking at one of the central problems with the premise of the entire franchise. The story needs engines that can travel many times the speed of light, as well as the equally (if not more so) fantastic transporters. But the story also requires Data to be unique....
Freakish as it may sound, I don't like TNG because I just don't believe in Data. The problems you mentioned plus the general mind boggling notion that a potentially immortal android wants to be mentally and physically impaired as he grows old and dies. Hard science fiction might look skeptically at replicators and unlimited supplies of antimatter (where do they buy that?) But Trek has never been hard sf.
As for Voyager and talk of energy shortages, scarcity of torpedoes and the like, if such things were silly and illogical, then they should never have been emphasized in the first place.
Exactly!
But the series did emphasize them in the first season, and then sought to forget them afterwards. And the inherent lack of consistency in that is the silliest thing of all.
But I think you could reasonably suppose sticking with a bad idea is the silliest thing.