Thinking back I came to the engineering side of things back when I was a student in the early 80s. I managed to talk my way into helping out with the people who did sound for the student union gigs. Learn a bit about live sound, earn a bit and get to see bands for free, what's not to like? Other than heaving around the huge PA bins and 4x12 stacks of the time. But you can do that stuff when you're young.
So I learned my way around a mixer, gain, eq and stuff like that. Which made using a cassette portastudio easy.
My first experience with DAWs was based round that. Not too difficult getting stuff tracked, and access to a range of (virtual) equipment only high-budget studios had in any quantity which I then had to get my head around, but previous experience helped a lot.
In other words, a gradual learning process over years as technology changed. What I could not and can not do is be a real sound engineer of the kind who can whip up a suitably customised Baxendale eq circuit or a programmer who can code a software equivalent. Fortunately I don't need to be.
For an absolute beginner with no prior knowledge the learning curve when they first run a DAW is somewhere between steep and vertical. Apple have tried to make it easier, and to some extent have succeeded. Core Audio/MIDI is easier to deal with than picking the right ASIO driver, making sure there's nothing causing unwanted dpc latency and so on, but even then you still need to know about latency, you still need to at least know what MIDI does, including it's not audio.
Apple's answer I guess is the free Garageband. A mini-DAW I actually find hard to use, I suspect because I know more than I'm supposed to so find it's workflow and approach counter-intuitve. Logic Pro when installed defaults to a "Garageband on steroids" interface and workflow intended to make the transition from one to the other easier. Then when the user finds they want to do stuff that they can't in that environment, or feels brave, they can switch on "advanced preferences" and get into Logic as a DAW that's similar in many ways to Sonar and as complicated as all the other "front rank" DAWs.
But even then there's a heck of a lot to learn to get things working well and to understand what's going on. It's not a quick or easy thing to learn, and I guess you have to have a certain mindset not to give up and either hire a studio or decide the whole thing's too dificult and too expensive.
However, I think Apple's approach does have its strongpoints. There's no way around having to learn some stuff, but if the amount of stuff needed to be learned at any one time can be kept to managable chunks it helps a lot.
Consider software synths. Many/most of them have a huge number of parameters - multiple oscillators, wave-tabling, lots of different filters, complex modulation matrices, often on different pages or tabs and often a bunch of stuff that's unique to that synth. Compare that to a Minimoog or an MS-20 where every one of the limited number of functions has a dedicated control, the patch can be taken in at a glance, how any function changes the sound is easy to find out and experimental pot-turning and switch-throwing is rewarded by something obvious happening. And despite(?) the simplicity still sound really good.
Which is the better tool for learning about synths and getting to understand what the components do? I strongly suspect that many, maybe most soft-synth users rely heavily on presets, partly because the instrument is so huge and complex that patching it yourself is far from easy.
I guess what I'm heading towards is that maybe for beginners what's needed is a DAW that lets them learn a bit at a time. Or, better, a DAW that offers a "beginner's configuration" that can be turned off once the basics are learned. I can see no way to avoid some "book learning", because there are things you can't avoid needing to know in the same way you can't learn to play violin without knowing what the strings and bow do, why it needs to be kept in tune and tuned to specific notes etc. So accessible information about why there's a gap between playing a note and hearing it and what to do about that gap is essential. Which with PCs takes us into having to get to know a bit about how PCs work and do things, but again that's unavoidable.
I think Sonar's introductory tutorials are very good, but there's that saying about taking a horse to water.... Not everyone bothers with them, as shown frequently by questions to this forum. Which brings me to something else I think is essential (and almost unique to Cakewalk). A friendly, helpful and well-informed forum where no-one is made to look stupid for asking about something they don't understand, very little bull, they don't get told to "go use google" and no-one gets put-down for not using the latest, greatest and most expensive kit.