IMO your husband’s requirement for passenger roll down windows is simply code for “I don’t want a minivan.” You will have to work that out among yourselves.
I own a ’06 Caravan, bought as a left over for cash. The rear wing windows are powered, the passenger air vents are under the front seats and have their own control. I don’t carry passengers often but have never had any complaints. It has had some problems. The front disks tend to warp and pad wear is abysmal, but aftermarket rotors and ceramic pads seem to have cured that problem. The EGR valve failed and the front motor mount had to be replaced. Now pushing 80K the rack and pinion will soon need to be replaced and the A/C evaporator has a slow leak. I’ve opted to charge the system once a year for about $60 rather than pay $1100 to have it replaced. All are common problems for this era Caravan. Sounds pretty terrible doesn’t it
This comes to my issue with relying too much on CR for making car decisions. IMO over the years the gap between “better” and “worse” has become pretty narrow. The system CR uses amplifies the difference between the “best” and “pretty bad”. It is a kind of stack ranking where there are winners and losers even if the loser is acceptable. My Caravan looks pretty bad compared to a Honda. Still it has never left me stranded, done everything I asked, gets reasonable mileage for what it is and its paid for. At the time I bought it the Honda Odyssey was about $8000 more. Despite a few problems I haven’t come close to spending the price difference on repairs. CR is a good resource but that’s all it is. It shouldn’t be used blindly.
The first couple of years I owned my Caravan I drove less than 3K a year. I lived in the city where I worked. I walked to work most days and entertainment was also with in walking distance. Sometimes I could go a couple of weeks without driving. A local bus got me to and from the airport and the bus/train station was across the street. Ironically I used it mostly for grocery shopping.