Firsty, gocyrus, for someone who was not going to give any BS you sure did write out a lot of BS... why not just write out every well known commercial release and a few others to go along with it.
Just to push the previous points, if you want free, go Protools. If you really get into music and willing to pay I see 3 options but 2 that I like. To get it out of the way, I was never into Cubase but it is a very good program if you use the features it has (you never did say what in music you are doing).
Logic is my choice and with an OSX version 'round the corner it is a HEAVY contender. I have not seen in a long time because I never used it but they used to have 2 MAJOR versions of that software, micro and regular. There have always been variations of the regular version to accomodate different specific needs but the regular version is flash and has not only great MIDI handling and support BUT FANTASTIC audio handling.
On the other hand, if you are gonna look into PCI cards and other real Pro type stuff, I feel, and MANY other high users feel, that there is no option outside of a good ProTools set up.