Part of me always wishes that the fight scene between Hayes and Reed ended up with them making out, let's face it the sexual tension between the two of them was probably the best in the series!
Also, though a deleted scene and not considered canon, I have it in my head that Martin Madden became XO of the E-E following Riker's departure.
And how good does he look for 57!
Commander Austin Harris, First Officer, Deep Space Nine (by FltCpt. Bossco)
8.01 - Darkest Before Dawn
(Chapter 8 added, 12/09/2015)