I vote for the principle of getting only what you need.
Occasional people plus bikes: Small car or wagon plus roof rack.
Infrequent snow: Front-wheel drive plus an extra set of four rims holding snow tires. Swap seasonally. Or do without - drive slowly and short distances only or stay home on snow days. Always pack suitable shovel(s) just in case.