Archi just wrote up a ton of DSD/PCM measurements based on HQPlayer upsampling so many people swear by.
http://archimago.blogspot.com/2019/02/measurements-look-at-hqplayer-325.html
There is no objective gain whatsoever. If people like their DSD512 upsampling, it is the 'euphonic distortion' they prefer. Although, an exception could be with DACs featuring chipset optimised for DSD. Holo spring, T+A DAC DSD come to mind. Outliers rather than the norm, though.
Can you explain what is the "euphonic distortion"? Apart from some noise problem in your measurements (maybe digital decimation filter of the ADC or poor PCM conversion in the Oppo), I don't see any particular distortion.
My closest DAC to that one is Pro-Ject Pre Box S2 Digital with dual ES9038K2M. And it performs quite nicely at DSD512 and doesn't have increased noise floor.
Here's S2D with 1k tone at 44.1k/32 PCM input:
And here same source file, but DSD512 input:
Result is quite a bit less harmonic series, but equal noise floor. Btw, in the lower one you can also see a little bit of USB packet ticking at multiples of 8 kHz.
Another example is RME ADI-2 Pro (uses AKM DAC chips), it behaves in similar way when running in DSD Direct mode. But if we look from another aspect is oversampling ratios...
ADI-2, same sweep as earlier, digital filter set to sharp, 44.1k input:
Since the digital filter runs at 8x rate and then rest over oversampling is done using sample-and-hold (aka zero-order-hold), there are images at multiples of 352.8 kHz digital filter output rate. Remember that these images have adjacent both negative and positive frequencies that are fully correlated with the source signal! So any intermodulation products they may create in later stages (like power amp) are also fully correlated. So if you hear it sounds like artificial hardness. Overall; images = incomplete reconstruction.
Then we run it at DSD256 instead:
Here you have a little bit of DSD noise hump left at much lower level than the images with PCM input. And this noise is uncorrelated. Intermodulation with uncorrelated noise -> noise. If you hear it, you hear hiss like analog tape or radio background.
Then if we look at iFi iDSD Micro Black Label (BB/TI DAC chip).
This time for example IMD plot, 44.1k PCM input:
Difference tone is at -100 dB and you can see starting noise hump and spurious tones of the on-chip modulator. And digital filter suppressing image of 20 kHz tone by about 80 dB.
For comparison the same source, but this time running at DSD512:
Now the 1 kHz difference tone is down to -120 dB. No digital images and no noise hump visible here. 8 kHz USB packet ticking has come up a bit, closer -120 dB though.
Just few examples with DAC chips from three different vendors.