I don't mean to speak for Jeff, but I think his statement about 96/24 was more situational - i.e., there are situations where it's demonstrably better and the resolution makes an audible difference.
DeeringAmps
And, was it Z3ta2, when NOT oversampling, sounds better at 96k; BFD!
Well, I'm trying to be a gentleman regarding products from other manufacturers. I think it's more "diplomatic" to pick a Cakewalk product that can emulate the performance of other virtual instruments that can't oversample.
For 99% of the work done is Sonar I'm pretty sure we're "safe" at 44.1.
I think it depends on what kind of music you do. Given how many virtual instruments and saturation algorithms I use, I'm not in the "safe" camp but I would guess most people are.
ESPECIALLY if the user is going to "master" (small m) his/her own material and convert to mp3.
I'm very glad you brought that up, because it's something I forgot to mention. If something does sound better at 96kHz, as noted previously any "goodness" remains if converted down to 44.1. But, it also sounds better if converted to a quality MP3 (e.g., 256 kbps).
And I'm pretty sure that 48/24 is WAY better than the best tape machine, especially after about 50 passes.
There are a lot of people who would argue that, but I'm not one of them. FWIW, if you think about it, tape with a 100kHz bias oscillator has a sort of "sample rate" of 100kHz because it's lining up all those little magnetic particles at that rate.
But I don't have to admit nutin'.
Nobody saw me do it...
What happens in Sonar, stays in Sonar. Well, at least until you release it...