Yes, except if the area to be deleted contains instructions for what the area after the deletion is supposed to sound like, how is SONAR supposed to know that you aren't deleting those instructions
on purpose because you want the part after the delete to continue on from what was happening before the delete? Clearly, in the example of the gradual time change I gave above, the intention was to have a slight change over time. So if at the cut point you now have a jump to the new tempo, that's not what was intended.
The core of the issue seems to be that there's no "rule" that's going to work every time. I think the best anyone can hope for is a rule that works
most of the time, but that manual editing is going to be unavoidable in some, maybe even many, cases.
The problem re tempo changes as I see it is if you check Tempo Changes when doing a Delete Hole, and there are tempo changes within that hole, the results aren't consistent. I think the only possible solution is to choose a consistent result for what happens, but realize that a lot of the time, it's not going to be what you want. However, at least you'll know in advance it's not what you want rather than finding out afterward.