Picard didn't go through with the Borg Queen storyline they teased for Seven of Nine, because it would've been bleak.

Although Star Trek hinted Seven of Nine could be the Borg Queen, another Picard character was a better choice to become Queen and change the Borg.

Also, the bit where the Borg Queen slingshots Picard and his team around a star to initiate the time travel was awesome! Season two isn ... Back to the Future 2 'bad Biff future stuff', and ...