Any wagon with a 2.3. The motor size in my view about as small as you want to go with a bigger car like that, you need all the passing and merging power you can get.
I have talked myself out of pickups about twenty times in my life, I have the need for them but not very common, the minuses far outweight the pluses to me. I found that by taking like Tempo 4dr. you could remove the rear seat to get to and remove the rear support/crossmember under the package tray to then be modded to bolt right back in and then you could completely bury a fairly decent chunk of 8 ft. long lumber completely inside the car with trunk closed. The looks at Home Depot when people saw you loading were priceless. The Contour rigged the same way.
Still past a certain point you need more and wagons get me 7/8ths to everything that can be done in a truck in my world and better gas mileage the rest of the year. I've carried refrigerators in the back of a Focus wagon as well as some pretty bigscreen TVs. The wagon has a mileage price too but not nearly as bad.
One thing I don't care for with a wagon is how the a/c degrades with age to not keep all that area cold like when new. I have no trouble getting the air ice cold, it's the crap fan blowers they make now that in no form or fashion blow half the air a new factory blower does. I'd thought a time or two about moddiing the inside of the Pinto wagon to put a divider right behind the seats to make the a/c'ed compartment area much smaller, one day I may do it when/if car comes back online.