I have a Nemo Astro, Thermarest Basecamp XL, and a bunch of others depending on use...
The Nemo is a great ultra light and small pad and I find I use the small ones most often. It doesn't need to have foam in it. I'm also big 6'5 / 240 and with 3" of air it's great. Only complaint is the horizonal air passages. My previous ultralight pad had vertical air chambers and this is the way to go. This is where the big agnes has the nemo beat. These all compact to less than the size of a football, why carry the extra crap if needed.
The thermarest Basecamp is good but in a year I had a hole. Thermarests seem to pop a lot in my opinion. It's only 1.5"
The best best "car camping" sleeping pad I have is a Wilderness Technologies pad that is 3" and super cheap. One has a hole and its so thick you don't notice it. Hard part is finding the 3". These are massive though, pretty much unneeded and very seldom used.
Only advantage to lots of foam is easy / very quite teardown times, and generally self inflating if you have poor lungs.
You do not want to breathe into a sleeping pad it you intend to use it over winter. The moisture freezes in the pad and gets really cold. Just FYI...