
Exped
MegaMat Series
Car camping comfort champ, but some side sleepers find it thin.

Running these analyses costs money. Buy through my links to help keep lights on! I may get a small commission.
I'm 53. I only backpack 2-3 times a gear and car-camp maybe that much, too. A good bed is worth the extra weight. I've never owned one as expensive as the two you mentioned,but ypu gotta find those holes. I love my thin foam roll, my oversized, square - bottom, hooded top, lightweight sleeping bag, my 2' x 24" x 76 wide Klymit air pad inside that, and me in my fleece bag liner on top. All that only weighs 6 lbs, and can do a wide temp range.
1. foam pads outperform their ASTM rating. I personally feel comfortable taking my 2R CCF pad down to freezing, and a number of people agree with the assessment that a CCF pad is 3 season capable. Most of those generic egg crate z-lite knockoffs are 1.7 to 2R which is fine for summer or even 2 season conditions. Sometimes you get lucky and get a true 3 season pad for cheap. 2. Your numbers are a bit conservative, but that also depends on location so it may be right wherever you are. For air pads, I’d agree somewhere near 2 is fine for summer, like the Klymit uninsulated pad is 1.9R and a fine budget summer pad. Thermarest neoair xlite is the UL 3 season gold standard at 4.8R. However as stated, CCF sleeps warmer in the real world and a 2R CCF pad will sleep just fine in a lot of 3 season conditions. for example I used a z-lite for every step of the AT and now a switchback for the Oregon coast trail, a 1000 mile LASH of the PCT, and the PNT. to OP, the main issue is do you find CFF egg crate accordion pads comfy? if you do, it is like unlocking a cheat code for putting together a cheap, light, comfy sleep system. I’m lucky in that one of these pads is enough for me but I only recommend it if you aren’t sacrificing sleep.
Ahh ok then yea low or no R-value would be fine in those cases. Klymit also makes a good lightweight low R-value pad, it's what I used in Texas and worked quite well in warmer weather. Not as heavy or thick as the one you linked, but much lighter and packs down smaller. Great if you're backpacking but there are better options if car camping imo. Exped Ultra 1R is also a good pad, the more insulated 3 and 5 are also popular for colder temps. I've used the Dura versions which are a heavier/more insulated version and it was comfortable. I've also heard good things about Nemo Tensor but have no experience with it.
My car camp pad is an exped mega mat, wonderful. Saw a cheaper version at Scheels by Lightspeed? Dense foam with air and it holds well. For backpacking, I need lightweight and use a Klymit5, love it, but 3 nights on it I’m wanting a hotel.
My favorite is the klymit static-V pads, they make extra wide and doubles, insulated or not.
Did they change the valve? Both mine have twist valves.
I have tried many sleeping pads and have never had a problem sleeping on any of them. I have a Klymit Inertia X Frame pad that works great because it’s designed to go inside the sleeping bag. Love the fact that I never roll off in the middle of the night and is less likely to get punctured. It weighs 19oz. Will also add that I did a bikepacking trip in Canyonlands and had no trouble with my $69 Klymit. Meanwhile my brother’s brand new $250 Thermarest leaked air every night of the trip so he basically slept on the ground.

Exped
MegaMat Series
Car camping comfort champ, but some side sleepers find it thin.

Exped
Ultra Series
Lightweight side-sleeper comfort, but a bit pricey and bulky.

NEMO
Tensor Series
Ultralight side-sleeper comfort, but slippery and prone to leaks.

Big Agnes
Rapide SL Insulated Sleeping Pad
Comfortable with side rails, but heavy and warmth claims disputed.

Therm-a-Rest
NeoLoft™ Sleeping Pad
Very comfortable, good service, but heavy and bulky for backpacking.

Ranked #1
Exped - MegaMat Series

Ranked #1
Exped - MegaMat Series

Ranked #1
Exped - MegaMat Series

Ranked #1
Exped - MegaMat Series

Ranked #1
Therm-a-Rest - NeoAir Xtherm Series