Toyota offered their 3rd Gen 4Runner (1996 to 2001 IIRC) with a 4cyl engine that had roughly the same output as the previous generation's V6. It wasn't a speed demon and was only rated to tow 3500lbs, but the one I drove with a 5spd was peppy even with 3 folks inside. IIRC, the rated mileage was about 20mpg in town and 25mpg on the highway, compared to 15/18 for my V6 version (exact same vehicle, just a different engine).
That would be about perfect for someone who did light towing (utility trailer, small camper, small boat, etc) or wanted 4x4 for moderate offroading, driving on the beach, etc. It would be a lot more capable than then car body "SUVs", but get almost the mileage they get. I came close to buying one shortly before we bought our V6 version, but missed out because I hemmed and hawed about the 4cyl. When I made the decision and went back to the dealer, someone was already filling out the paperwork on it.
Chris