Given that you personally can hear up to 384kHz and that ther's so many music material originally recorded at 768kHz that is a real shame.
I am aligned with what most recording engineers believe. 48KHz/24bit is all what you need. For classical music, probably you can go up to 96KHz/24bit.
The catch here is that most DACs now upsample the data to 192KHz internally. A lot of them will do PCM to DSD conversion internally.
Feeding DAC with 768K or DSD512 data will bypass most of those upsampling functions inside the chip.
Usually sophisticated computer software can do a better job here. Sure, if you are willing to pay big $$$, machines like Chord or dCS will have powerful on board DSP to do a job equally as good.
How about PCM 1536K or DSD1024? The problem is the clock speed now is very high. A good low phase XO will be very expensive to get.
It's also a problem with ESS DACs which use 100MHz for the DPLL function. DSD1024 will pretty much render the 100MHz DPLL ineffective.
4493's on board DSP is fairly good. It does very well with CD 44.1K data.