Propellerhead's Reason program is awesome. It acts as a digital "rack setup" where you can have a ton of effects samplers, amps, etc. It also has a built in drum machine (as most pro audio programs do) and support for midi devices (again, like most progs do). The learning curve is sorta steep, but if you have ever used "real" rack equipment it's simple and very nice.
It also has a cool feature that when you press the TAB key you can see the back of the "virtual rack" and move and rearrange patch cords to suit your needs.
Also, I have a friend that has made some cd's, of himself playing, with cubase and they sound very clean, and professional.
In addition to Pro Tools, there is also a program called Logic that I've heard is decent.