I shoot exclusively in full manual in either matrix 95% is the time and highlight weighed meter the other 5% of the time. I tried using spot meter in auto iso a couple months ago with my Z9+800PF. I was getting some crazy exposure adjustments and have up on it after 2 burst sequences of balls takes.
I just leave nothing for the camera to control as it can get fooled far to easily. Plus with real time exposure in the EVF, i have no clue why anyone shots in Auto ISO anymore, especially if you have a Z lens with a control ring to set it for ISO control.