Back in 2015, I posted some images taken at ISO6400 with the D3. Now it's the Z9's turn. and it does much better than its ancestor. Here are some photos taken at last year's Dia de los Muertos event, the only night event that I attend with some regularity.
It's a bit of a cheat though, as I used TopazDenoiseAI to clean up the noise. Still, the extra resolution helps reduce the noise when re-sizing the files. And yes, Topaz does a lot of the heavy lifting. I've limited the auto ISO to 25600, as it seems that's the limit where the camera and software work together to give decent images.
I know I used the Z7 at Dia several years ago, but the results will be close enough to the Z9 that it's not worth the effort to re-process them.