Cambridge Audio CXNv2 upsampling everything to 384Khz

This conclusion is false. As you can see, it’s the CXN (V2) that does the up-sampling (your points 4 and 5). This has nothing to do with Roon and it’s settings. If you use a digital output of the CXN (V2) then this up-sampling is irrelevant (not applied) as it only affects the D/A conversion (analog outputs).

About your point 7: What else do you expect here? The digital inputs of the CXN (V2) support a maximum sample-rate of 192 kHz.

PS: This is common behavior nowadays. Most (any?) of the integrated DAC chips do this (up-sampling to the highest supported sampling frequency before doing the D/A conversion) and offer filters (linear phase, slow roll-off, …) for the user to choose from. Buy a non-oversampling (NOS) DAC if you don’t want that to happen.

See also: