I'm not sure that there would be a huge difference between the sensor performance of the D500, Z50 and Z50II. If someone has had some, or all of those cameras, and knows better than me, please post. I went onto DXO to try and compare the sensors of those cameras, but it looks like they have not even bothered to test the Z50 and Z50II.
I don't see huge increases in sensor performance in recent years, and things seem to have plateaued compared to the previous 20+ years of sensor technology progression.