A lot of what you are going to want is going to depend on what (exactly) you are going to use it for...
I use Cakewalk Pro 9 and Sonar (on occasion) -
I use it to sequence backing tracks for multi-track recordings of Original compositions and Cover tunes - and also to edit midis I find online (in an attempt to make them sound less screwy)
Tell us what you need this proggy to accomplish, and we can make some recommendations