But how many dealerships even have base models of the ones you listed consistently in stock? From what I've seen with the type of car I've been looking for (base model AWD Camry hybrid) a lot of them are either being built and are sold already and the dealership's just waiting for them to land on the lot, or they're in transit and a pending sale. From what I understand, dealerships don't make as much money on base models as on loaded ones.
You're right---there's more profit margin in the more expensive trim levels. And base trims don't sell well. Never have. It's why Impalas outsold Biscaynes and Galaxies did multiples of what the Custom 500 did back in the day.
Why? The natural urge to splurge a little on something you're going to live with (most likely) for the better part of a decade, the helpful (*cough cough*) salesperson letting you know the step up is only a few bucks a month over the life of the car loan, and---for those who don't drive the wheels off and might want to trade in four or five years---resale value.
I don't know where you are, but there are currently 269 base Camry LE AWD on dealer lots around the country, priced from $31,039, with the vast majority in the $33s:
As for the other examples, most people buy neither the Honda CR-V base trim, nor the top of the line---the bulk of the business is in the mid-level EX-L at $35,400.
Camrys start at $29,600 without AWD. The hot trim level is the XLE at $34,800.
RAV4s range from $31,900 to $43,300---but the plurality are XLE Premiums at $36,100.
And so on. All good, popular cars---among the best-sellers in the country---and none of 'em at $50k. Again, it's the trucks, SUVs, luxury cars and, yes, electrics, that are runnning up the average from the other end.