If you want a conventional sedan, then the excellent advice above should be your guide. However, someone has also pointed out the idea of a minivan, which offer more versatility and space than a sedan…consider vacation trips, etc.
I’ve been extremely pleased with my Dodge Grand Caravan, it’s comfortable, smooth, and quiet, V6 engine running beautifully at over 292,000 miles, though the engine is definitely tired. But it still does 22mpg highway, and not bad on oil. I recently spoke to someone with a 5 year old Caravan, she said it gets 27 mpg on the highway, and it was their third … they like them a lot, mentioned the fold away rear seats easily making a flat floor for hauling cargo. She also mentioned that their previous one had some sort of built in child seat which she really liked. In the 90’s and a bit later the longer wheelbase version got the “Grand” designation…three rows of seats. Now I think they are all the longer size, not sure when that changed.
A post on another thread elsewhere on this site from one of the experienced mechanics said that the engines are generally quite good. But as Caddyman mentioned, the transmissions are a different story, so look for one that’s just had a new trans installed. Alternatively, keep an eye peeled for one with a failed transmission for very cheap and investigate the price of rebuilding the transmission…roughly $1500, at least that’s about what I’ve heard locally. You might get more for your money that way… maybe a newer car for the same total price. The downside it that you won’t be able to test drive, which is significant. In a case like that, look VERY carefully at how the car looks inside and out, in the engine room, and even underneath, listening to what your instincts tell you about whether it was cared for or abused, and ask for maintenance records. If this route appeals to you, visit a a local independent transmission shop before purchase and get their thoughts on the concept, and judge if you’d like to deal with that shop. Then you’ll have comfort in knowing that the transmission should be good for over 100,000 miles.
Since you don’t have much concern about snow, avoid the all wheel drive versions as they impose problems and extra expense if you damage one tire and have to replace all four. You could probably find a very nice one from late 90s under $3000. Keep an eye peeled for one with a new transmission, then pounce on it …before someone else does.