It's probably worth it to spend a little bit of time learning the fundamentals, but like with programming, you can self-teach pretty well by just learning the absolute basics and then developing expertise through experimentation, trial-and-error, and pursuing what interests you.
Just as you don't need a 4 year degree to become a competent programmer, you don't need to deliberately study and practice music theory or classical technique for months/years to become a competent musician. In both cases, you can learn and practice by doing, if that's what you prefer. You can take a "hacker" approach for both domains.
I also don't really think there's any software that "handholds" or "guides" you in the way you're describing. Can you give an example? If it's a drum machine, you still have to program the patterns yourself, for example. Your DAW won't structure your tracks for you.
We could talk about Baroque vs Classical and that switch over into what the standards were. Or how hip-hop turned from a musical expression of life (and certainly not because of living up to some musical standard) into something that is right at the forefront of music today!
I feel like a corollary would be youtube vs movie studios. Sure, one is more expensive than the others, has standards, etc. But sometimes those things don't mean much, sometimes it's just about the story, the music, the authenticity of the feelings.