I'm running the following set up after much bivvying and camping. Like most I see the benefits and contrasts between foam and inflatable. Never quite enough padding in a foam mat, never as comfy or warm. Slightly bulky but bomb proof a easily cleanable...no worrying about deflation or wear and tear if it was an expensive inflatable.
Inflatables ...expensive, thicker, warm, more compact, can be punctured , in general take a long tome to inflate and on some that moisture reduces the effectiveness of the insulation (Exped Down feather filling for example).
There are work-arounds like foot pumps, hand pumps, electrical pumps and big-assed inflation bags.
After a bit of pottering using using a selection of pads my solution is the Thermarest Z Lite Sol folding pad AND a Nemo Vector Insulated Large mat.
They work in concert with the Z Lite against the ground as it is cleanable and can be hosed down and absorbs any stones and sticks. Over the top is the foot pump inflated Nemo which has reflective insulation so no issues with material compression or dampness affecting the insulation R Value-and no falling unconscious after blowing up a meaty pad!
Z lite benefits also include clean bivy bag so it maintains waterproofness, it is available in green and Coyote brown so it doesn't offend nature and the interface between the 2 pans is 'sticky' so no sliding around. the Z lite can also be used ans a folded sit pad or if folded in half a chair insulator.
Vector is warm, thick and quick to inflate with small pack size, no extra bits needed like pumps and its width is luxuriously wide which means that rolling around doesn't equal rolling off.
In conclusion I don't think each style of mat works in cold weather but combined they are a winner.
Nemo Vector
Thermarest Z Lite Sol