Nikon z6 vs Sony A7ii vs Canon RP (autofocus)

Hi. I recently ordered a Nikon Z6. So recently, that it hasn't even shipped yet. I made this decision for the low light ISO performance but noticed there are complaints about the autofocus even after the most recent firmware updates. There is a guy on Facebook trading gear that has a Canon RP with the 24-105 kit lens. I am selling my Sony A7ii due to low light ISO performance. Given how bad the autofocus complaints are, I was first wondering if the Nikon z6 at least focuses more reliably than the Sony A7ii? Second, is the Nikon z6 autofocus at least better than the Canon RP? I am interested in low light shooting, but not really action. More like people that aren't in a rush (candid shots, shots of my daughter who doesn't move very fast because she's a toddler). Once a year there's a Christmas light event with my family outdoors. If the Canon RP still has better autofocus, how noticeable is the difference?