The main difference would be the resolution, with SACD and DVD-A having the ability to theoretically preserve more of the original sound vs standard "half bitrate" DTS 748K, which I believe most or all DTS CDs are. When you step up to full bitrate DTS 1509K, it's fairly difficult to tell the difference between it and the typical DVD-A, IMO, but these are rare. FYI, DTS CDs essentially became DVD-A.
What all that doesn't tell you is the quality of the master and how well it was mixed for the format. If you use a crappy master, no matter how much resolution you have in the format, you aren't going to make it sound better. With an excellent recording, I think you will hear the benefits of SACD and DVD-A. To me there is no question that SACD has more detail than a CD, but with DTS and a good master/mix, it's already going to sound pretty good.