I thought they dropped the ball with Scorpion and especially so in later continuity. The idea of 'helping' the Borg because the species 8479 were the greater threat was a bit much really consider past Borg/Federation entanglements. Also a child could have guessed that the Borg 'started' the conflict so that came as no shock whatsoever when it was revealed and the subsequent episodes with species 8479 (posing as Starfleet Academy no less) jars massively with their "Your whole universe will be purified" statement. The only positive from the two-parter was the sight of 3 Borg cubes running away from a single Scorpion ship and the plot extension of 'rehabilitating' a Borg from the collective which took the whole Locutus thing much further than TNG was able/willing to do.
Year of Hell I didn't mind quite so much but again it felt very contrived. You wouldn't be able to convince cultures that they'd been altered by a "time ship" without being labelled a looney, especially if they'd never met you before. However, I enjoyed it more than Scorpion because I'm a sucker for time travel stories, even if they do contradict themselves.