Depends on the way you like to work, really. If you are good enough a pianist you could enter the lines directly in a DAW (I personnally use Logic, although I was a garageband user for a long time. It does fine up to a certain point). I don't like it though, I like to take the time writing everything down and I'm not really that good a keyboardist.
So I work with Finale because I know a lot of the shortcuts too. I tried sibelius a few years back but I found it less flexible. It was easier to pick up but ultimately more limited, in my experience. I couldn't rewrite and redefine chord symbols like I wanted, had a hard time with page layout (especially slashes), etc. As far as writing music to import in a DAW is concerned, it's not a big problem, but if you plan on writing for actual musicians to perform it can be a very serious issue. Can't really comment on Musescore or any other software, sorry.
That being said, I wouldn't trust either Finale or Sibelius to give a good result audio-wise. I use it mainly for the composition phase but I export it as a midi and import the midi in a DAW where I can better control every little details: sound fonts, EQ, panning, various effects, etc. This post-prod part is not really my thing but it's really worth it.