I have 3 - all inflatable. The closed-cell foam ones are tough and cheaper, but they do nothing for me comfort wise as I'm a side sleeper.
For trips where I can carry a bit more volume and want some extra comfort/warmth, I have a EXPED Downmat 9. It's expensive, but very very warm [R8] and extremely comfortable.
For trips when I want a superlight load and less volume [e.g. climbing trips], I have a Thermarest Neoair. Again, very comfortable [2.5" thick inflated], warm [R2.5], and compresses to the size of a smaller water bottle. It weighs 13 oz.
I also have an old school design Thermarest Prolite. It's a good mattress and very reliable, but it's low on the performance scale compared to the other two. It's also the toughest theoretically, but incidentally, I holed it on the first trip out. It's also the most versatile, but it's also very bulky.
The Neoair is my goto mat now. Yes, it's delicate, but I hate bulk and excess weight. If you hole it, you're hooped, but you can bring some "tenacious tape" or similar product to do a quick field repair [weight would be negligible].
Perhaps a foam-based Thermarest inflatable would be your best choice. Maybe look for one with a higher denier outer fabric. I sold a thermarest from 1993 last year and the thing was tougher than nails, but it was heavy and bulky.