Joining Tottenham was far from the dream move one Premier League star predicted, and he eventually begged his old manager to let him leave halfway through the season