Have you looked at the Ford Flex? They can be found used at a big discount from original selling price, and are available in AWD. It’s a full-size wagon, but worth a look at least.
I’ve had one for about a year, and my family loves it more the longer we have it. It sits up reasonably high, gets 22mpg on the highway and can carry 7 adults comfortably. Competing products with the same level of options as our Flex were selling for $10K above what we paid for ours, and the low-milage Flex SEL we purchased is loaded with tons of features. No problems with it at all so far.
That might not be a bad option for us. I’ll definitely look into it! Thanks. :)