I fully agree with this comment.
I wonder how much of the lack of character that some people experience on the manual cx-5 comes form the fact that the ECU tries to be too smart for it's own good. When driving around town and shifting under 4k, the throttle response and rev-hang can be very inconsistent. A tune would be able to address these concerns while potentially adding a descent number of ponies.
Re trading up to a 2.5L:
I really don't think that adding an automatic, 25hp, 250lbs and $2500 will somehow suddenly transform the Cx-5 that Ninja feels no passion for into a sports car.
It's the torque.
Swapping the 2.5L into a manual CX-5 would solve the "make you special" part of the equation and it would be easier than swapping a manual into an automatic CX-5.
Used, low mileage 2.5L's car be had with a warranty on car-part.com for 1,800 and the labor to swap the engine in would definitely be under 1000. That would make a slightly special CX-5