As I see it, this should be relatively easy to fix, too: Cakewalk simply needs to add a user-configurable box that says: "Cut off the first xx.xx ms of newly recorded audio and move it to the left by that length".
I think the root of this problem is there are so many sound cards out there where the implementation isn't the same.
On my Echo layla 3g, WDM only produces a small amount of offset <2.9ms, which I can't hear. I agree with you when you say 8 ms is unreasonable.
ASIO on my Layla produces a considerably larger and audible amount of offset (it actually plays the recorded track back early.).
And someone wondered a practical reason for going out of your d/a converter and back into your a/d converter.
Sometimes people want to run their softsynths through hardware (preamps, compressors, outboard digital stuff etc).
Also for doing a stereo recording where you are using a combination of software synths and hardware synths in Sonar.
I once had this offset problem (because Echo recommended using ASIO over WDM in Sonar). I definitely think more should be done about these issues. I guess the good thing is, it keeps me from wanting to spend my money on trying out other sound cards fearing I might have an offset problem.
And I don't think manually sliding every track you just recorded in place would be a good example of Sonar's great workflow. I can see if someone was trying to create an effect or correct a sloppy performance but for general recording that is not acceptable.
It sounds like you want a perfect solution though. I would think if they could just get the offset to a minimal point (under 3ms), most people would be fine and there would definitely be less complaining.
I think this problem also hits people who do a mixture of midi and live the hardest. I ran into this problem when a guitarist (who's been playing since he was little and had good timing) couldn't lay down his part properly to my sequence. He got really frustrated, but I knew what the problem was.