If Mbappe's goal is to win the Champions League, it is natural that he will move to a club that has a greater chance of winning, such as Manc City, Real Madrid, Munich or Barcelona.
However, the one who really needs a pure striker right now is Real Madrid. And we know Real Madrid is the defending champion for the Champions League. He has a big chance if he joins there to win the championship.
How many times have he and PSG been defeated by these clubs in the preliminary round. I have to be honest, PSG's chances of winning the Champions League are still very far away compared to the clubs I mentioned earlier.
I think only Real Madrid, Man City, and Bayern Munich that have bigger chance to win UCL title. I'm sorry I exclude Barcelona because it seems hard for Barcelona to win UCL title with their current condition. Mbappe should move to those 2 teams/clubs if he wants to have a good chance to win UCL title in the future. However, I think Real Madrid is still the best team in UCL which already wins more titles over other teams. Real Madrid also has a great coach and potential players to be stronger clubs in the future.
PSG will be always difficult to win UCL title because they have no proper mentality to win it. PSG has no player who can influence other players to play consistently during the match. It is the role of the captain team or the senior players who have a lot of experienced in the competition.
I agree with you that Real Madrid, Manchester City, and Bayern Munich are the favorite clubs to win the uefa champions league this year, but let's not write other clubs off because the uefa champions league has a way of changing clubs' winning mentality when it gets to the knockout stage.