I don't know what is going to do best in your climate, something else important to consider, but cavendish types are less cold tolerant than Raja Puri. It seems like it's a favorite of many because it's easy to grow and cold hardy. I recall the texture being more chewy, much like a namwah. Certainly more dense. For may taste, they aren't my favorite, but then neither are cavendish types. I've had some locally grown DCs and Williams that were quite good, and I've like my own DCs, but ripped out all my Williams.
The cavendish types and other AAAs tend to have a more soft texture, have no sub-acid (tangy, apple, etc) taste, and are considered very sweet. The others you are considering are sweet, but to me not as sweet and have a better, more complex flavor. Texture wise, none of your options are hard or mushy (though I'd consider cavendish types more mushy than bananas with some B in them).
These are my taste reports of the the 3 you're considering. Just my opinion of course, though I tried to be more descriptive and objective:
Mysore taste report
Tall Namwah Taste Report
Raja Puri taste report