Just a follow-up for anyone searching in the future:
I did get my old M-Audio Delta 2496 to play nice with Sonar, but I found that I had to set the latency to around 23msec (1024 samples) according to the ASIO driver. This caused live keys to be delayed just within the acceptable range, but any shorter delay would cause my more busy projects to suffer the usual low-sample artifacts (static/drop-outs/pops, etc.).
I put a price watch out for a few audio interfaces and eventually purchased the Scarlet Focusrite 2i2 for $99. Just got it and tested its performance versus my M-Audio Delta 2496. The Focusrite ASIO maxes out at 10msec latency with 1024 samples, so that was a bit concerning since I couldn't include more samples when I needed them (larger projects).
However, even when I reduce the # of samples on the Focusrite to say 512 (5msec delay), it still performs like the champ on projects that would cause artifacts when playing through the M-Audio Delta 2496. I'm not knowledgeable about the hardware/driver inner workings, but I would have assumed the # of samples and latency value would tell the whole story, but obviously not. The Focusrite performs much better given the same reported ASIO parameters.
I suppose I'll keep both audio interfaces installed if in the future I need to raise the # of samples on the M-Audio Delta 2496 to 4096 (its maximum ASIO setting) when not recording live MIDI on a very complex project.
Thanks again for your help.