As said, off road = Jeep
Around town shopping cart and tourer (as in my case because it's what I already owned) = Chevy Sonic 4-down, automatic. I can haul bikes on the rear hitch of the car and haul kayaks or a 12' canoe on the roof racks. Interior storage is pretty good with the rear seat down.
I ran a separate charge wire in order to not pull a fuse when towing. The ignition needs to be in the "ON" position.
Every time I gas up I start the engine for a few minutes to circulate the tranny fluid.
Car is only 3000 lbs. and tows nice and easy behind my 24ft E450.