Do picture styles affect the output of RAW files when processing them?
I think Adobe have done their own profiling of the camera models they support; their profiles are 're-creations' of the manufacturers' own profiles and standard presets (styles), which are proprietary. Perhaps this has improved in CC, but for me the Adobe camera profiles never quite matched Nikon's own, which I preferred. In the CS days ACR didn't care, and couldn't read, what you had actually set in-camera (apart from white balance), so Adobe's approximations of the Nikon styles always had to be selected manually - has this changed?
I mean, I can tell ACR to use (say) Camera Vivid by default, but what I can't do is tell it to 'match whatever picture control I set in-camera, shot by shot', which is what NX-D does. It ignores my in-camera setting, at least in CS6/ACR9. But I've just read this has changed specifically for Z6/Z7 files in CC:I don't use CC. But I have always been able to automatically apply a camera profile (be that an 'approximation' or not I don'[t know) on import into LR. It can be changed manually after import.