Do the geometry in your head. Something full length and non-inflatable that is even a mere 1" thick is going to be bulky when folded or rolled. You are not going to find such a pad that packs down to a size comparable to an inflatable.There is an exception to that math that may offet the OP an acceptable compromise. If some of the thickness is in the form of nesting egg crate shapes, the nesting will make it take less space when folded. The Thermarest Z-Lite is 72"X20"X.75" so it is 1080 cubic inches. It folds to 20"X5"X5.5" which makes it take a bit more than half as much volume (550 cubic inches) when folded. Not as small as many inflatables but substantially reduced compared to other foam mattresses when stowed. If I was worried enough about leaks to go foam, I would probably buy a Z-Lite.
All that said, I still much prefer my NeoAir's light weight, comfort, and compact stowed size. I find that, with care, leaks are rare, usually easy to repair, and generally of the need to adjust the air once during the night variety if they occur at all.