Blame the OP, not me
the ones that say they "need" AWD when they don't

Lots of good cars that don't meet that "requirement" but check all the other boxes.
Honda's CVT is awesome, so if AWD is still "needed" that would be a good choice even though it has a CVT. It has no turbo, no DI, decent ground clearance, good fuel economy, and yes, AWD
The AWD also hurts fuel economy.
WAIT! I just remembered about the Matrix/Vibe AWD! The Vibe was made until 2010, while the Matrix made it until 2014. There was AWD available on it, no turbo, no CVT either
The 03-06 AWD will get better mpg than the 09+ gen duie to having a smaller engine (1.8L vs 2.4L)
The Suzuki Aerio SX from 03-07 ish was available with AWD and no CVT. Unfortunately, the SX4 that replaced it has a CVT.