The CX-5 and Outlander aren't available with AWD and a manual. Only FWD and a manual on the base trims. I wouldn't consider a Mitusbishi because they have not made a competitive car for a very long time. Their current lineup is still lackluster.
The CX-5 is the best option I'd say. It is fun to drive, efficient, and reliable. I would test drive it to see if it is powerful enough. The previous generation had the underpowered 2.0L on the base trim with a manual. They make one of the best traditional non-DCT automatics, but it ain't a manual. Road noise and the stiff ride are the only complaints I would note from 2013-2016. 2016 had a better infotainment system and some other upgrades. 2017 was a major redesign without a manual. The 2.0L engine is good for the small Mazda3, but not as much in an SUV. The manual is definitely the better choice to use all 155 hp.
The best "automatic" transmission is probably the VW DSG found in the Alltrack and many other VW products. It requires maintenance every 40k miles or so, but I think it is worth it. The manual is available with the S and SE trims. I would just worry about long term reliability with the Alltrack because VWs usually need some expensive repairs when they age. It is the only SUV/wagon I could find that has a manual and AWD except the Subaru Forester.The Subaru is a good choice, but less engaging and Subaru isn't an option for you.
If you want something not mentioned, the Honda HR-V is worth the look. It is more efficient and smaller than the CX-5 and Alltrack, but the trunk is much larger and more useful than the numbers suggest. This is the major selling point of the car. The LX and EX trims have a manual. The manual has longer throws I've heard and is not one of Honda's best manuals. Reliability will be up there with the Mazda or maybe better.
Alltrack and CX-5 are my top choices. Please tell us what you buy in the end. Good luck!