Many of you know me as a long time contributor to this forum, so I hope you will read my words with some amount of trust and at least let it enter your logical consideration on what to do about your DAW situation with this Cakewalk news.
First - let me say that I'm saddened by this development and wish that it wasn't how it is. I am a "lifetime" subscriber and, while I think I got my money's worth in updates as we were going, I also know that I will stop using Sonar either now or soon and those benefits will have been lost. I'm also a hobbyist. I don't make a living doing this or even any money, and I don't get much time from my professional life for my hobbies, so I haven't been that productive with the new features and have no interest in getting bogged down later by software that doesn't work - leading me to have to fix things just to be able to enjoy them.
So that's my perspective.
There are a lot of posts that have a tone of believing that Sonar will be safe, effectively forever; that as long as the activations work, the software will also and will be able to be re-installed without issue. I've seen many state that they believe that the Windows Updates that are sure to come - and (for most) are unavoidable to keep an up-to-date system - will not stop Sonar from working.
I think that this is incorrect. I do IT support for a living, running my own small business with several technicians working on small-to-midsized business IT environments. I have seen a few recent Windows updates roll out that have been quite destructive. One about a month ago prevented many servers from being able to boot at all. Of course, this sort of issue would affect ALL DAWs (and other software for that matter), but many others have been software specific. Notably, there was one that came for both Windows 7 and 10 that rendered a few applications for our customers completely inoperable when it came to integration with Excel files - a function needed to be able to use the application for its function in their businesses. The manufacturers of the software in question (one manufacturing barcode printing application, one enterprise database application using SQL for the backend) simply recommended that either the updates for those systems had to be turned off or an upgrade to the software and/or a patch would be required to get around the problem. In both cases, the customer was interrupted and lost hours of time, expense, and had to choose between turning off updates (not safe for security) or dealing with a broken application while they await a fix from the vendor.
In the case of Cakewalk, that fix would not come. This would be the effective equivalent of Sonar working fine as long as you didn't want to use any VST effects or instruments. I don't think that would be a reasonable problem to have.
That situation happened over night in all cases. No warning and basically no sympathy.
So for those believing that they won't be affected negatively by this possibility, I think you should strongly consider thinking again, or accepting the "frozen system" methodology to not have to encounter the problem.
Myself - I don't have the budget to do much at this time since I don't get a lot of time to "play", but I'm leaning towards Studio One like many others here. I've downloaded the demo, found my way around, created a drum map for my Pearl Mimic Pro, made sure I understand how all of my external gear works (or doesn't) with the software, and started poking around, watching videos, and experimenting to determine if this is my way forward. The "deal" that they have to crossgrade out of Sonar at this time will likely entice me to making that a Christmas Gift wish for the year. Sonar will become a memory.
As said, I'm saddened, but I've also had some support issues lately that went unanswered without constant hammering to get a few minor issues corrected - it took a nearly year of badgering for fixes for bugs that had been around since at least X1. The whole skylight interface, while pretty, lost loads of productivity until the most recent revisions. Many features that worked well before were inexplicably removed (like track layers) when X1 came along. Hardware devices (like the short-lived VS700, the Mackie Control mode under X1+ no longer supporting many features it used to (like EQ mode that controlled the Sonitus), the Contour Shuttle Pro not having a working plugin to the software any more, ACT being basically a complete pain and somewhat abandonware) lost function or became completely unsupported and useless. There are probably tons of reasons why Cakewalk was doomed to inevitable failure - these are just the few I encountered.
I hope that we can all continue a sense of community either here or moving along to another shared-software-venture that many of us are sure to take.