In my opinion the gas engine is pretty awesome with 6MT. I put my foot down and it revs to redline in first real quick, then a hard shift into second gets the tires chirping. The engine makes a kind of unusual but still interesting noise. It is entertaining. It feels good when I go down a country road and I'm spending all my time over 4K RPM. It is not fast but it feels fun, and that's what really counts, if you ask me.
Chances of a turbo performance CX-5 are very low and next-to-none in the U.S. Chance of a diesel here is not high and if it arrives it will be expensive and a high-trim model only. Remember, if the manual did not get a really nice highway MPG number, we probably would not have received a manual option here either. Mazda clearly put out a 6MT base model only because of the EPA numbers they can advertise.