You could argue he's gone no place but down since leaving us.
He could do just as well at Juve or PSG who are no less prestigious than City.
What do you mean by his planning for City to be his legacy? Seems to me he went there because his friends were there and they'll pay him a lot and he'll leave when he feels the players are no longer responding as he'd wish.
Pep from his own mouth stated City as legacy for what he leaves there.. playing style, youth set up, CL trophy etc. At Barca he knows that is Cruyff.
Leaving for Bayern and then onto EPL after he had done all he can at Barca is completely different. From City job there is no real attractive move.
Other than change in family situation cant see plans being changed.
He is a sleazy boy though so family maybe not so important.