My money is the hero ship for Season 3 being the E. I imagine it going something like this:
There's a crisis and JL looks at Riker and asks, "Where's our ship?" Riker's Response is, "Worf is on his way with her." Cut to shot of refitted / upgraded Enterprise-E dropping out of warp.
Another scenario - JL looks at a few of the crew who have assembled to take on crisis / threat and says "We are going to need a ship." LaForge (now promoted to chief of Starfleet Corp of Engineers) says, "I think I've got just the ship, she's state of the art and the most advanced ship in the fleet." Cut to shot of Enterprise F in space dock powering up.
There's a crisis and JL looks at Riker and asks, "Where's our ship?" Riker's Response is, "Worf is on his way with her." Cut to shot of refitted / upgraded Enterprise-E dropping out of warp.
Another scenario - JL looks at a few of the crew who have assembled to take on crisis / threat and says "We are going to need a ship." LaForge (now promoted to chief of Starfleet Corp of Engineers) says, "I think I've got just the ship, she's state of the art and the most advanced ship in the fleet." Cut to shot of Enterprise F in space dock powering up.