It used to be much,
much worst in the late 90s and early 2000s when Cakewalk was widely dismissed and frequently referred to as
a toy.
Despite its qualities, Pro Audio was seriously lagging behind in terms of features, partly due to Cakewalk's refusal to support VST and rely on ASIO. They did try to re-invent that wheel for years...
So while Cubase, Logic and the others were offering low-latency, virtual instruments and all the other goodies, all Cakewalk had to offer was a very basic (though solid) audio-midi sequencer.
The fact that it was PC-only didn't help. Pro Tools, Digital Performer and Studio Vision DSP were Mac only. The valid alternatives - Cubase and Logic - were both cross-platform.
Pro Audio was like an alternative to the alternatives, and as such, usually dismissed.
So while big studios were being equipped w/ expensive Pro Tools TDM systems, other folks who could help build a reputation - cutting edge major league artists like Nine Inch Nails, who were moving away from traditional studios and helping set the
private/home studio trend usually adopted Studio Vision DSP, Logic or Digital Performer, because these could be used w/ Digidesign hardware, while providing the MIDI features they needed.
The other people who can help give a piece of software its credibility and bring out its name, like the people scoring movies, were opting for DP, Cubase, Logic, for reasons still obvious almost 15 years later.
Lastly, both Cubase and Logic being made in Europe and cross-platform, it's no surprise that they were the apps of choice for the folks at Computer Music and other such publications based in Europe, further marginalizing Cakewalk.
So back then, telling people you were using Pro Audio typically got you the same kind of reactions you'll see when someones says he's using a Soundblaster.
Nowadays, Sonar is usually accepted as a valid alternative - not so much because it actually gained recognition and earned its place, but, sadly, because it's been commonly accepted that technology progressed and alternatives have become valid options.