IMHO, one should pick C4S only if there is absolutely no option except to go for AWD. It's more important to get winter tyres in snow/cold conditions (below about 7C). In very icy conditions, AWD may help with greater traction.
A more 'positive' reason for getting the C4S is the wider body. But you will struggle to notice 22mm on each side unless you are actively looking out for it.
However, what's the price one pays? IMHO, the steering of the C2S is much, much better. It's light which makes the car feel so much more agile and nimble. In a C2S, 100% of the power is behind you. 62% of the weight is on or behind the rear wheels. Only 38% is in front of the rear wheels. In a C4S, between 5%-40% of the power goes to the front wheels. I love the RWD sensation. Like a Tonka toy. Bigger wheels behind thrusting the whole car forward. The front end going light. Using the rear weight in a different way through high speed bends. It's a rare pleasure. The AWD C4S loses that appeal for me. It handles like other cars would handle. I love the sensation of being pushed through bends from behind. I prefer that to being pushed partly from behind and also partly being pulled though bends by the nose like a buffalo with a ring and rope though its nostril!
With all the power going to the back wheels, the traction out of corners is amazing. With a rear LSD, like I have on the -20mm, it helps even more.
People mistakenly argue that the 911 isn't a special enough experience. They couldn't be more wrong. The RWD experience in a 911 is a sensation which very few cars offer today.
The C4S has the same red caliper brakes, same discs etc except, on top of what the C2S has, it has an additional feature: a system which pre-prepares the brakes to be operated. I can't remember the exact detail but you can easily read about it in the 997 brochure. It's all in there.
I have a C2S. I'm biased in the sense that I made a conscious choice between C4S and C2S and went for the latter. Would I do it the same again? 100% for sure I would. But I live in London so all we get is rain. It hardly ever snows here and even then, it hardly ever settles. Yes, it gets icy in winter but careful driving is fine. I don't even have to put winter tyres on so you can realise from that how mild our winters are.
My advice to you is that in poor conditions, use winter tyres in winter and always exercise extra caution. That will help you more than enough.
It goes without saying that I voted for the C2S.