He was great with Real, but not all of the time. There were some years after Del Bosque when the team sucked and couldn't win anything. That's when he started thinking seriously about retirement.
As for Juve, you know what his greatest match in his whole career is, according to him (or rather...