Yes, the CX5 has been popular so I don’t think you’re going to get any great deals on year-old models. Plus, the first year they only offered it with the 2.0 liter engine, which many felt was a bit short of performance. Now they also offer it with a peppier 2.5l that gets almost the same gas mileage.
So for used the Mazda model the CX5 replaced is the CX7. It’s handsome, but most were turbocharged and their bad turbo lag made them unpopular. In later years they sold them also without a turbo, but those lacked much in the way of performance. Anyways, it isn’t nearly as desirable as the CX5, though if you see one at a really good price you could do worse.
It’s in that lower tier of models with stuff like the uninspiring Nissan Rogue and Hyundai Tucson. Various Mitsubishis, too. I’d put the Kia Sportage of recent years a step ahead, but that’s mostly just because it looks cool. It’s not that special otherwise and has a reputation for a stiff ride. Still, all of these will cost less than Toyotas and Hondas and some are decently made. Check the Consumer Reports guide for reliability. There are also a ton of Ford Escapes/Mazda Tributes (basically identical) out there. Not much loved, but common and cheap. They made the older one for about a decade and certainly had the opportunity to work out the bugs before coming out with the more stylish current one last year. Not sure if they did get all the bugs squashed, but the older model is a simple vehicle without as much to go wrong.