As to the OP, all DAWs these days are pretty good. They're also all flawed or have limitations, which is why there isn't just one DAW that everyone in the world uses. But I believe there are several reasons why so many people are simpatico with Sonar.
1. Windows can be a really iffy environment. Cakewalk works very hard to have Sonar be as compatible with as many different systems as possible. There will always be some people whose system won't be happy with some particular piece of software for some reason; a quick glance at any forum for any DAW or interface will confirm this. Unfortunately, the way technology works gives three main choices: those people need to find non-Sonar software that's compatible with their particular system, find a system that's more compatible with Sonar, or learn enough about their existing system to make their own fixes (the example I always like to use is graphics cards, because it seems so counter-intuitive that a graphics card can bring an audio system to its knees). Wishing that Sonar or the hardware on which it runs will magically change won't produce tangible results.
2. Sonar focuses on music creation. As that's the goal of many people (as opposed to something more esoteric), Sonar will take care of their needs better than software with a different focus.
3. The previous comment notwithstanding, Sonar does LOTS of different things well. If you look at what people do on this forum, it's everything from bands to songwriting to narration to audio-for-video to EDM to creating sample libraries. Not that many DAWs are as good at so many things.
4. Sonar has a personality. Its developers hang out on the forum. When you work with Sonar, it's not with some faceless corporation, but with Noel, Ryan, Seth, Andrew, etc.
5. This forum. Most of the people who inhabit this forum seem like the kind of people you wish were your neighbors.