IMO, get the auto tranny, it's the better tranny for a SUV such as the CX-5. And it's easier to sell later too.
On the rare occassions when you really need the control of a manual, the manual mode works very well. The manual mode is unusually good and better than all in this class of SUV's. But 95% of the time I typically use the auto mode with good results.