I don't think people who can meet there needs with public transit are the target market of many car manufacturers. Most truck miles are driving to work and the store. Your use case sounds like it would be perfect for renting a vehicle, especially since it would save you from storing and insuring it an extra 300 days per year.