My take on pads ... your mileage may vary.
I have spent days on end camping off of a raft and spent 6 weeks living out of a tent at 11,000' in the middle of winter. I have slept on thermarest, foam/inflatable (paco pad) , air, fleece jackets, etc.
Air mattress. Hands down. My current air mattress has probably 70 nights on it. I bought it for $12.00 to try out air mattresses camping. For a full rig. I'll buy a nice one. Coleman makes them. Don't worry about durability, you can buy one of much better quality than mine and worse case scenario, 5 minutes and you fix a leak. But I never have had a puncture. Mine does lose a little air overnight, but no biggie, and it is a cheap one.
An air mattress feels like a real bed, can be adjustable depending on how firm or soft you want it and no pad, inflatable 3.5" foam pad, etc. will compare for comfort. I have taken plenty of people down the river who have never slept in a tent before or only do it rarely. They have difficulties sleeping comfortably on pads, wake up multiple times per night, etc.
Overall, there is no comparison for comfort, especially if camping on uneven ground. On top of that, packing is a big difference. Things like Paco Pads do not fold up, compress easily. They are much bulkier to store and take up much more space when not in use.
It boils down to how comfortable a bed you want.