I record in either 24/48 or 24/96 for my multi track gigs. Admittedly I'm a small fish in the world or recording engineering. The beauty of digital is that once I mix down to track and master the mix a file copy of that 2 track will sound the same as the master. The only difference will be in sound will occur due to the difference in playback hardware. I've never worked in DSD but many rave it's sound.
When I archive and transfer analog tape I use 24/96. Believe it or not there is a current argument claiming that properly dithered 16/44 or less, is all that is needed to to maximize the transfer resolution of any analog tape. I've been involve in some of these discussion and don't subscribe to this belief and argue that my own listening test tell my ears otherwise but these folks are smarter than me and throw all kinds of math and science at me telling me I'm buying snake oil and only gilding the lily by using anything beyond 16/44.
If anyone is interested in my work, which is all on location live concert recording, I would point you to Frank Vignola Trio with Bucky Pizzarelli, Live Standards or Felipe Salles, Timeline, or Ronnie Leigh, live at Apple Jazz...to name a few. These are only available in cd but I do have the hi res 2 track master mix. I also have 3 more releases coming out next month.... 1 is a limited run surround mix, the second is a blue ray dvd....which will have 24/48 audio and the 3 will be a mostly acoustic jazz concert on cd. All of these will be released on the Apple Jazz lable.
I'm not trying to pedal my wares but give you a frame of reference from which I speak, albeit, just a very small part of a much larger industry.