Cranesong HEDD is the only studio unit I know that's actually designed to add color, with knobs to add triode/pentode harmonics and tape emulation. (It's also a quite pricey item.)
Others (like the Apogee) are really just designed to be more accurate--which can produce a more pleasing sound by offering better fidelity, but OTOH, also ought to reveal a lot more of the bad aspects of digital. I don't know how it translates in a club, but in the studio, if there's clipping, a good DAC lets you know it real well, and having one is a real eye-opener to how much bad digital sound there is in the world.
I'm sure there are audiophile DACs out there with tube stages n such, but I reckon they'll be at least as pricey.