"Mazda not offer it until 2l next decade or so when they go mostly electric vehicles." - NormT
That Equinox is $23k. Considering it is already $5k off MSRP according to the listing (I think the MSRP is wrong), I doubt they would negotiate.
You should be looking at the Toyota RAV4. It is the most reliable compact SUV. The Escape is unreliable and I hated my Escape rental because it felt 2,000 lbs heavier than it actually was; it felt like it was going to roll over in normal turns. NormT only suggests GM products and will nitpick every little thing on non-GM cars while picking all the "good" parts of the GM. None of these cars will have CarPlay unless an update comes though for Mazda with the Mazda Connect infotainment system, which I've read is happening.
The Toyota RAV4 2013+ comes well equipped even in the base LE trim. Backup camera, touchscreen infotainment system (a good system), and keyless entry standard. Spotless reliability history (it is probably the most reliable Toyota). It is boring, but many people don't mind that. My mother in law drives a 2014 and can't stop talking about how much better it is than her old Saturn. It is the default choice for a no-frills reliable small CUV. It handles surprisingly well, but it isn't as fun as the CX-5. It doesn't feel as substantial as the Equinox in the doors and road noise, but is still comfortable. This would be my top pick.
The 2014+ Chevy Equinox is an OK SUV, but why get one if it doesn't have the reliability record of the RAV4 or CX-5 and is super old-feeling? The Equinox and Terrain do not have as many features as the RAV4 and are some of the most well-known rental cars. They don't have as much road noise as most CUVs and the ride quality was good. The only reliable years were from 2013+, and these years were still not as reliable as the RAV4. I would say the Equinox Terrain before 2017 were considered old and behind the times (just look at interior pictures). The engines were outdated and MPGs were not good. The only reason I would see someone (other than a rental fleet) buy one is because the car feels more solid (like the doors and ride/noise) than the others and the higher depreciation. Otherwise, beats me...
The Mazda CX-5 is another great choice, but it does have a lot of road noise and feels tinny compared to most other options. The ride is firmer than the other CUVs. With the worse ride quality comes the best handling in the segment by far. It handles like a much smaller car. The ones before 2017 would not be my first choice. Fuel economy was also a strong point in FWD and AWD (it has a good AWD system). It isn't everyone's favorite, but it perfectly fits your requirements and preferences. It is very reliable.
The Honda CR-V is my second choice, but it does have problems with idle vibration on the CVTs, so maybe a 2012-2013 with the 5 speed. I didn't like these as much as the RAV4 because the RAV4 has a nicer interior and more standard features. Honda kind of cheaped out on this generation.