DACs that upsample to DSD internally?

Maybe I used the wrong term. Maybe it should have been oversampled or resampled. At any rate, I have over 1,000 CDs ripped to wav files and have used more than one NOS DAC. I found a lack of detail in them. I would like to listen to them in DSD format as many many people say it sounds wonderful. 

The one I'm using now is a no name one built from a very inexpensive assembled kit that I bought on here some years ago. I got it for using when I was "in between" DACs. (I would sell one then buy another to upgrade) My last one was a Metrum Octave, but even that didn't have very much detail. I'm not sure which to buy now, but I thought I'd go in the totally opposite direction and try DSD. In any case, my current DAC is by far the weakest link in my system.

@williewonka 

My cables do need upgrading also, I have Cullen power cords, a Morrow IC, and usb and digital cords are just from Blue Jean. I recently had dedicated power lines installed. I thought I'd try to find a good DAC before upgrading the cables.

@mahler123

Thanks for the response. Do you have any choices? I mean could you listen to PCM if you wanted? If not, can you choose between 64, 128, 256?

@kijanki 

Sorry, I meant output as DSD, even when the input is PCM

@williewonka 

Thank you for taking the time for the comprehensive response. I didn't mention before my DAC is battery powered. I don't even know if the USB port needs to be powered through the cable or not, but if so, would I need something like an iPurifier?

@georgelofi 

Why? I just want to try DSD. Maybe I won't like it at all, I don't know. That's the only reason, and probably the only reason all us on here try different equipment. 

Thanks to everyone for your answers!