It depends what part of the frequency range you're comparing. E.g. WH1000XM4 vs Airpod Pro 2s: https://www.rtings.com/headphones/reviews/sony/wh-1000xm4-wireless#test_423
https://www.rtings.com/headphones/reviews/apple/airpods-pro-2nd-generation-truly-wireless#test_423

WH1000XM4 isolate best at around the 40-50Hz region, Airpod Pros do much better than the Sonys in the mid range region where voices predominantly are

My advice: stick with your Airpod Pros. I dont think any over ear ANC options will be a worthwhile use of your money and many will have worse sound quality

Don’t

KZ are not competitive. In fact theyve got caught with a few different controversies - e.g. advertising with multiple drivers, not all of which actually do anything. Or changing the tuning for the worse after loads of positive reviews and measurements come out. Pretty much all of their models are V shaped tuning with harsh treble until that KZ collab I just linked… which they changed anyway

I would advise looking at Moondrop, Salnotes, 7Hz for a start. Chu 2 could be a good option.