I've tried a lot of backpacking pads over the years. All of these have gotten at least a few nights under me, most have gotten at least a season or more:
Big Agnes Air Core (uninsulated)
Thermarest RidgeRest
Thermarest Z-Lite
Thermarest ProLite
Thermarest NeoAir X Lite
Thermarest NeoAir All Season
NeoAir pads = bestest ever, IMO
From all of this I've learned that for me, size is paramount. The way I sleep, I like to have extra length and extra width so mummy shaped pads are no good. If it's going to be a smaller pad, I like them to be closer to the ground so I can flop off of it a bit without being too uncomfortable. Larger pads I like to get the full cushy depth of inflatables like the Big Ag or the NeoAir.
Insulation is critical. I don't sleep cold so it never really seemed important to me, but once I started sleeping on the NeoAir pads, I learned the real power of insulation. It makes it so I can pretty much use my 32˚ sleeping bag as a quilt for pretty much everything but winter camping. The way it reflects heat back up just makes the whole system so incredibly efficient.
Closed cel has the insulation, but the comfort factor is just terrible. I slept on the RidgeRest for a couple of years. It was awesome to have around the campfire, not so awesome to have a huge roll on the outside of my pack. Terrible for aches and pains the next day.
The ProLite's were okay but bulky. Didn't really love them or hate them. I had issues with holes in them a few times.
The Big Agnes was also okay but I'd never go back to an uninsulated pad. I also had issues with holes in it, but BA was awesome with repairs.
Oddly, I haven't had any issues with holes in my NeoAirs and I have used the hell out of that X Lite. I'm now using the All Season as my go-to pad unless I'm really cramped on space or room. It's a bit heavier than the X Lite but having that fully rectangular space is worth it to me. I wish I could get an old verion of the X Lite that was fully rectangular in the XL size. That would be perfect.