If you're looking to prioritize comfort, look for a thicker mattress that will support your body and protect you from the hard ground while camping.
Memory foam is likely a superior choice over air mattresses since the latter can sometimes deflate throughout the night.