I've never felt like he would spend more than five years at Madrid. It started off poor and has turned into a giant lose-lose situation. The direct comparisons to Messi, the absurd pressure heaped onto Jose and the squad to win everything every year (and Jose being a threat to leave every year), Barca racing past them as an organization, La Liga financially crumbling. As of now I'd honestly say that he's wasted the prime years of his career at Madrid.
He and especially Kaka royally assfukked their legacies with the move.