The end result is still 16bit/44.1 kHz. No amount of magic will change that. As this is still "homerecording.com," I doubt that many, if any of us are producing audio for DVD, SACD, or DSD... Besides which, the ADAT lightpipe spec maxes out at 48k; any box that offers more than 48k over lightpipe is using two (or more, in the Pro Tools HD 192kHz situation) channels at a time.
I'd love to hear someone on this board do the same song at 96/24 and at 44.1/24 -- for example, have a band play the same song live twice, and record each performance at a different sampel rate -- then see if anyone on this board can accurately pick the difference from the final 44.1/16 mixes. Since I've heard this done several times with classical music, I feel pretty confident that the results will be 50/50.