in my opinion, the best multi-track recording software is like choosing a woman to be with. there are times that the first one is the best since you learn to appreciate and learn more about it as the time passes by. sometimes, you just have to try another software since you have a hard time with the first software you used and realized that there are way better recording software around. also, there will be times that you have to keep several software since there are specific needs that a specific software can only give.
in the end, it would just be best to start with a good tested recording software, learn and discover its up and down. research alot about it and love using it every time it's open and serving you in the pc.
serious answer, Ableton Live
This is a very subjective topic but I find that it depends on how a person works... and even thinks.
For one thing, it primarily depends on whether you approach recording in a linear or non-linear fashion. Traditional sequencers such as Pro Tools, Logic, Samplitude, Sonar and Cubase tend to favor linear thinking since these more closely resemble tape recording, whereas Live and FL is more of a non-linear approach since it is primarily loop-based. The division between linear and non-linear software is now becoming blurred since some DAWs include loop manipulation apps, an example being Sonar's Matrix editing which was derived from their defunct Project5 software - a direct competition to Ableton's Live.
One doesn't need the best software out there. As a long time reader of Future Music (along with it's associated CDs and DVDs), I have listened to some reader demos that were done using basic software and barebones equipment, and the results were both stunning and amazing. I guess it all depends on one's clarity of vision and the tenacity to which you hold on to it, regardless of what you have.