It depends entirely on the type of music you want to make, and the method you are most comfortable working in. The following is a broad generalization:
Reason is sequencer or pattern (loop) based program with sample playback and a cool assortment of synths and such built in. But it does not sample sounds itself - anything acoustic or from outside the program, you have to sample with another program then import. The sound of the drums isn't a deal-breaker, there is a wide variety of "refills" - sound libraries that you can buy and add to Reason (as there are for all other sample-based audio programs).
Abelton Live is particularly good at taking live audio sources, chopping, looping and mixing them together, especially quickly, or even in live performance. It is an acquired taste and talent, like scratching, that if you cotton to it can be immensely creative.
Cubase, Logic, and Digital Performer are classic MIDI Sequencer + Digital Audio + software plug-in studios that extend the multitrack tape analogy to computer production. They are complex and powerful - not as immediate as Reason and Live, perhaps.
ProTools is primarily an audio production studio with some MIDI capability and less facility to integrate with VST (software) instrumens and plug-ins tha the other 3, But it is a defacto standard in the industry
Nuendo is Cubase on steroids with a particular focus on audio production for film and video.
Hit the library and do some reading -- Sound on Sound, Keyboard, Electronic Musician, Recording, Computer Music, Future Music magazines all have reviews and how-to articles on all of the above.
Thanks
Trevor
CanadaRAM.com
