I really like Ableton. There's a learning curve, of course. But I feel like I really know my way around it now.
I'm sure other DAWs are great but I chose Ableton and it's what I stuck with and got proficient with.
I've been using a version of Cakewalk since 1990, and have grown with it. Back then it was only MIDI and required the MPU-401 by Roland (or a very close clone like the one I had a CMS-401). Cakewalk today is now Cakewalk by BandLab, still has active development and is more stable than it has ever been, and is free. It is fully featured (though at the moment does not come with many VST and none that are fully function third party - I think).
What does it do right? The MIDI functionality is still very good. The Audio processing engine is great.
What doesn't it do right? I think, and this is just a guess on my part, Third Party VST support. Most of the crashes Cakewalk SONAR ever had were related to VST plugins. It isn't as bad now, but can still happen.
Unfortunately, I can't help with the survey, as my use of DAWs is 99.9% limited to that one time a month ago I tried Ableton Lite and decided it's way too complicated for what I use MIDI for, that one time a month ago I tried Reaper and decided it's way too complicated for what I use MIDI for, and MAGIX Music Maker (demo) for a verrrrry brief stint way back in the early 2000s.
I don't create any music per se, I tend to edit MIDI files that already exist, and MIDI-specific editors are better suited to it than a full-fledged DAW.