I bought a new car a year ago exactly, after my trusted and sporty 1998 Civic died on me (my fault, I won't elaborate....). Because of my job as a flight attendant at the time, I needed a car to commute to and from the airport a few times a week, and no other adequate form of public transportation from downtown where I live was available in Calgary, except taxi, at about $100 roundtrip. But since I needed that car only for the commute, I opted for the cheapest, most economical car I could find. I tried the usual suspects (Honda Fit, Toyota Yaris, KIA, etc.), and while they all offered great value for the money, there was no fun factor whatsoever. While I always bought used cars in the past, I came across a deal for a Fiat 500 I could not pass for a brand-new model that had been sitting for three months at a Dodge dealership (in a city where pick-up trucks/SUVs are kings and the chances of selling a Fiat were pretty slim) after it had been won in a contest and the winner chose money instead of the car. I test-drove it, and I was hooked. What a fun car to drive, peppy, with great handling, and enough room to haul stuff with the rear seat folded down. It is not a family car by any stretch of the imagination so if there are more than two people in your equation, it will not suit your lifestyle, but otherwise, this sporty little thing attracts the attention, is way more stylish compared to anything in this class and price (the Mini is another contender, but more expensive even for the base model) and has fantastic gas mileage as a bonus. Under snow and icy road conditions, it performs impeccably if fitted with four good winter tires.
Now this was last year. Since then, I got a new job which requires me to fly to a remote location and spend three weeks there, followed by two weeks home. Since it is not practical and economical to drive to the airport and leave my car parked there for three weeks, I just take the cab to the airport if I have an early morning flight, and the downtown shuttle when I come back home. When I am home for my two-week stay, I rarely use the car, so it stays parked in my garage most of the time except for a trip to the grocery store or the occasional Sunday drive, which seems to be your projected usage. If this is the case, if I were you, I would simply be car-less, and explore other available options if I ever needed a vehicle: rent a small SUV for camping trips or to go skiing (apply for a travel reward credit card that includes car rental coverage), use a car-sharing system like Car2Go to run occasional city errands, and bike/walk/public transit the rest of the time. That would be the Mustachian way. If you really want your own car, which is fair, go for something cheap and economical, but fun, like the Fiat 500 or the Mini.
