Lol, so what we have to look forward to is the following teaser:
Next season on Enterprise, Worf, Data, and Odo are sent back in time by one of the factions in the temporal cold war to join the crew of the original Enterprise. They are given strict instructions to not divulge any information on the future, unless absolutely necessary (which will happen every episode). The Enterprise is refitted with transwarp drive, and transphasic torpedoes to help stop the coming borg onslaught. Q will make 5 appearances, and turn out to be one of the factions in the cold war.
Admiral Janeway will be out on a diplomatic mission where she accidently guides her ship into a temporal rift driving them into an entire other quadrant and timeline. This will seem unrelated to the main storyline, but will be used for a filler episodes as Enterprise will occasionally intercept communications from Janeway's ship as they broadcast through a rift too small to fit the ship through. Warf, Data, and Odo, will always look at eachother uncomfortably when these communications are recieved.
The Suliban, in an attempt to win the cold war for their unseen master (who will turn out to be Captain Kirk's body reanimated, mutated into a Romulan and then assimilated into the Borg collective, captured by the Ferringi, stripped of some implants and the freed to become an Andorian freedom fighter) capture a young Spock (who has always been in love with T'Pol it turns out) to use his brain as the master control computer for a giant armada (Comprised of Suliban cell ships, and Borg ships. These Borg are "nice" Borg and seperate from the collective and Kirk still has psychic contact with) that will destroy Vulcan and Earth in one swoop. The Enterprise is Earth's only hope, but it's hopelessly outclassed.
In the Season Finally, Janeways communications finally become clear. She has found a way to enter a wormhole that will bring her right to the center of the battle between the Enterprise and the Suliban/Borg armada. She only has 1 minute to make a second wormhole that will take her back to her own time. Fortunately, Janeway has adapted some new alien technology to her ship (a diplomatic skiff) which will allow her to destroy the alien armada in a matter of seconds, leaving enough time to beam Warf, Data, and Odo onto her ship and make the rift/wormhole. They leave behind all their equipment in their quarters onboard Enterprise, which will be locked, except when needed (every episode).
Season Four spoiler:
Season four will have Earth scientists find and ancient civilization of Leprechauns in Ireland. The Leprechaun's will form the backbone of the newly founded Federation. The Leprechauns are found to have advanced technology, such as Photon torpedoes (which are obsolete due to Worf, Data, and Odo). Their lucky charms will form the power source for the experimental "Braga Drive" system. The Leprechauns will withdraw their membership to the Federation, and thus bring and end to the "Braga Drive" program, once they find out their pots of gold aren't worth anything anymore in the Federation era society. They take off on magical winged horses who use their golden horns to sustain a warp field and oxygen barrier, as they travel to a new world to colonize and form a new society based solely on the idea of gold being worth a lot. They will be seen several times (One episode where they jump Enterprise to snag the communicator badges Worf, Odo, and Data left behind, because they think they are solid gold), including a glimpse of them from the time period of Picard in which they will have evolved to have very pronounced eyebrow ridges.