I had lower back fusion done some years back and due to that I need a thicker than normal lightweight bikepacking pad, so I went with a now discontinued Thermarest Basecamp air mat, a bit heavy but it does provide very good comfort. However there is a flaw, and this flaw would apply to ALL air mattresses, it doesn't take much to puncture one, on my very first outing it punctured, I did repair it, but that first night wasn't good; what sucked is this happened like I said on the first night, it was a slow leak, so it took 4 hours of lying on it for it deflate, when I tested it at home I only laid on it for 15 minutes, so did the leak come from the factory? if it did I wouldn't been able to prove it.
While I suggest an air mattress for their comfort I now believe that I wouldn't spend a lot of money on one, in fact cheap air mattresses are being made better every year. One in particular has a 4 1/2 star rating on Amazon with over 22,700 user reviews, that's an outstanding review, weighs 14.5 ounces, it's 2 inches thick for some real comfort, with 20 denier thickness for some degree of puncture resistance and is as thick as a full blow up job will get, and the weird thing is that is cost only $40!! At that price you could afford to buy 2, 1 for backup! It's the Sleepingo Sleeping pad:
https://www.amazon.com/Sleepingo-Camping-Sleeping-Pad-Backpacking/dp/B07FP4Z3RZ/ref=sr_1_1_sspa?dchild=1&keywords=Best+Backpacking+Sleeping+Pad&qid=1618104133&sr=8-1-spons&psc=1&spLa=ZW5jcnlwdGVkUXVhbGlmaWVyPUExNjBBWjZOMDVIOEEzJmVuY3J5cHRlZElkPUEwMDQzOTc0MlI2RUlWU1BCUkhPOSZlbmNyeXB0ZWRBZElkPUEwMzkyNzQ4MzRRN05NQzFUVlExRCZ3aWRnZXROYW1lPXNwX2F0ZiZhY3Rpb249Y2xpY2tSZWRpcmVjdCZkb05vdExvZ0NsaWNrPXRydWU=Here is a one year update on the Sleepingo:
https://www.youtube.com/watch?v=q74DcA7SXgMOf course the most puncture resistant sleeping pad is the Thermalite Z Pak, this thing is simply a foldable foam pad, but people do like it, and it only cost around $40, but it is rather bulky but lightweight, and you can fold it in such a way to set on it, however you feel ground imperfections when lying down on it.
Another option is the Klymit Static V2, less than $70 and has a high durability rating while weighing just a 1/2 an ounce over a pound.
This next and last pad is 4 inches thick! with TWO separate air bladders so even if you spring a leak you're still not laying on the ground, but it uses 40 D thick nylon, and it's only 22 ounces, it also has very high reviews and is under $35.
https://www.amazon.com/Trazon-Camping-Sleeping-Pad-Backpacking/dp/B08CCSB6B3/ref=pd_di_sccai_5?pd_rd_w=QYdOy&pf_rd_p=c9443270-b914-4430-a90b-72e3e7e784e0&pf_rd_r=TB87GE4GP1Q38DBP0MVG&pd_rd_r=b1e2d724-78dd-4daf-b553-c99f76b9e0b4&pd_rd_wg=k6zDI&pd_rd_i=B08CCSB6B3&psc=1I have some cheaper camping gear I got off of Amazon, and so far I haven't been disappointed, and if I ever do buy something and it turns out to be a dud then I'll send it back and try something different. But in terms of pads I really think the cheaper ones can do the job just as well, and all the reviews seem to indicate that is true.