That one would be very hard to answer as everyone has different needs and different driving style. For my part - CX5's tranny is perfectly fine while I granny-drive it, but for everything else - let's just say that whatever logic there is behind how it shifts - it rarely aligns with what I want it to be doing.
Another good example would be highway driving. Often - when going uphill, the engine is already waaaaay out of it's optimal RPM range, but the tranny just keeps feeding it the 6th for the sake of fuel millage. So whenever hitting hilly stretches - I'm almost always switching into manual mode anyways to use appropriate gears. Might just as well be driving a real manual.
It does not downshift to 5th going uphill on the highway? You may have to give it some more gas or even use the step pedal.