
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.
What about the Bestway AlpineLite that's available on Amazon? Weighs roughly the same as the Decathlon and higher R value. As for packed size, I just fold mine so it remains mostly flat and put in my pack.
I'm still loving my Decathlon MT500 Air - it's not insulated, but I slept on it down to freezing temperatures, though that wasn't really that nice. The normal one is about 50€ and weighs 500g, they have an insulated version for 80€ now, but that one is heavier of course. As for a sleeping bag, below 100€ is hard unless you don't expect nights below 10°C.
I'm a side sleeper, use something like this https://www.decathlon.fr/p/matelas-gonflable-de-trekking-mt500-air-l-180-x-52-cm-1-personne The trick is to not inflate it fully so it has a bit of give - I've found that it almost needs to be so that if I'm sitting on it I'm on the ground, but if I lie down I'm on a soft mat.
No, you do not want something like this usually. Although the brand is decathlon, this is essentially the same as an air mattress: its very bulky and heavy. If we stick with Decathlon, the product you want is something like the “Forclaz” line: this is a more common “backpacking” sleeping pad. Its smaller than a water bottle and less than 500 grams. The key takeaway though is this is going to be much narrower than your used to: average camping pad is 20-25 inches wide. https://www.decathlon.com/products/forclaz-mt500-air-mattress-189392?variant=41133720993854
the inflatable one from decathlon is comfortable. i thinks it is the MT500 Air.
A friend of mine has a Exped 5R sleepmat. I can very much recommend it. Good R rating of 5,2 and a dept of 8 CM. It also feels very sturdy and as added bonus it has a inbuilt airpump. The only reason I haven't bought it myself yet is because my current sleepmat (Decathlon Simond MT500) is still good enough.

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