Been flying through CDG, in and out to SFO and out of DXB.

CDG is the best so far, obviously. If you're CDG based I suggest on arrival just fly to another city to enjoy it even more

SFO: P escort on deparature to the plane / arrival. Deparature expedites security (I have TSA Pre so there's rarely any line anyway), arrival doesn't expedite immigration but at least you pick up your luggage from oversized luggage area. On deparature you'll go to the Virgin Atlantic lounge (which is now airside). Virgin Atlantic lounge is definitely better than the AF / KLM has and at the time there's a lot less people. Suggest not to eat very much.
DXB: Escort on deparature (expedites security and immigration) and you go to another lounge (only departed using P so don't know how good that lounge is against J).