If your going for an automatic, don't buy the Focus. The double-clutch in the Focus has been very problematic.
The Accord Sport is also a very good car you should try out.
Other people on this forum know more about the 6 and CX-5 than I do.
Good Luck