From what I can see, usually Ultra NR does a better job with same settings, and when settings are changed to get something similar, it mushes the image more with "enhanced" mode. For spatial NR.
Manual claims: "UltraNR is an AI-based noise reduction option that provides intelligently targeted noise reduction based on the machine learning of real world video noise patterns, rather than relying on a specific mathematical formula. This mode should give by far the best results for excessively noisy footage, as well as slightly better results with normal noise reduction. It’s designed to give an optimum balance between the wanted reduction of noise and the unwanted softening of the picture."

- sshot-1432.jpg (124.63 KiB) Viewed 1440 times

- sshot-1431.jpg (121.38 KiB) Viewed 1440 times
Sony FX6 test files for download
by Claus Andersen | Jan 24, 2021
XAVC Intra 4K, 4096×2160, 50 fps, S-Gamut3.cine/S-Log3, 4:2:2 10 bit, 500 Mbps, shutter 180.0 deg, ISO 12800, WB 5600 K. Approx. 1GB file. – Singer/Songwriter: Gorm Bloch
https://filmplusgear.com/sony-fx6-test- ... -download/