Joining Manchester United at the height of their powers under Sir Alex Ferguson would've been a dream come true for any player - so having it snatched away hit hard for one star