@minimejdh
The Global setting applies a Preset chosen from the select list, which can be either Adobe Default, Camera Settings or any Preset (Develop Preset) that you have installed or created in your LrC. This profile is applied as the Default settings to all RAW photos Imported into LrC, regardless of which camera was used to take the photo.
The checkbox option below the Global setting, Override global setting for specific cameras, allows for a different Preset (Adobe Default, Camera Settings or a Preset) to be used for specific cameras instead of the Global setting. This can be for a camera model, such as Nikon Z 6iii or a camera model with a specific serial number, as you have set.
The settings shown in your screen shot mean that Importing photos taken with the Nikon Z 6 3 with serial number 3011601 will apply Adobe Default as the Default settings on Importing photos taken with that camera. The Global setting means that any photo Imported into LrC that was taken using any other camera will have the Lens Correction preset applied as the Default settings.
"I created a preset using the Adobe Color space as the Profile in the Develop Module, zero on all the sliders, and lens correction. I am thinking I could apply this on import and that would take care of whatever is causing some of my sliders to be applied on import. I will create a preset for Camera Standard. Does this make sense?"
Yes, although Adobe Color is not a color space, it is a profile. LrC works in the ProPhoto RGB color space (actually a minor variant of it).
AdChoices