I'll save the only non-sequential two-parter on here, "That Hope Is You." Mostly on the strength of the first part, which I find INCREDIBLE. And part II... works well enough. The end of the episode sums the season up nicely.
TNG, Season 6: “Birthright”
TNG, Season 7: “Gambit”
VOY, Season 4: “The Killing Game”
VOY, Season 5: “Dark Frontier”
VOY, Season 6 & 7: “Unimatrix Zero”
VOY, Season 7: “Flesh And Blood”
VOY, Season 7: “Workforce”
ENT, Season 1: “Broken Bow”
ENT, Season 1 & 2: “Shockwave”
ENT, Season 4: “Storm Front”
ENT, Season 4: “Affliction/Divergence”
PIC, Season 1: “Et In Arcadia Ego”
PRO, Season 1: "Lost And Found"
PRO, Season 1: "A Moral Star"
PRO, Season 2: "Into The Breach"
PRO, Season 2: "Last Flight Of The Protostar"
PRO, Season 2: "Ascension"
TNG, Season 6: “Birthright”
TNG, Season 7: “Gambit”
VOY, Season 4: “The Killing Game”
VOY, Season 5: “Dark Frontier”
VOY, Season 6 & 7: “Unimatrix Zero”
VOY, Season 7: “Flesh And Blood”
VOY, Season 7: “Workforce”
ENT, Season 1: “Broken Bow”
ENT, Season 1 & 2: “Shockwave”
ENT, Season 4: “Storm Front”
ENT, Season 4: “Affliction/Divergence”
PIC, Season 1: “Et In Arcadia Ego”
PRO, Season 1: "Lost And Found"
PRO, Season 1: "A Moral Star"
PRO, Season 2: "Into The Breach"
PRO, Season 2: "Last Flight Of The Protostar"
PRO, Season 2: "Ascension"