We camp with a queen size air bed, and here are my thoughts after several years of use:
The beds that look like long parallel tubes are a bit bouncier and you feel your partner move more. The ones with dimples, like the ones you are looking at, are less bouncy and are the type I prefer. I find real bedding, rather than sleeping bags, makes camping so much more comfortable. I use a large rectangular sleeping bag opened up flat like a quilt as the first layer on top of the bed (except in very hot weather), then a quilted mattress pad, then the bottom sheet, the top sheet, and finally 1 or 2 more sleeping bags opened flat (or a down comforter). I have used this setup comfortably down to the low 20's without a heater. Real pillows with pillow cases also really add to the comfort. The sheets also make for easy laundering on the road, and I only launder the sleeping bags about once per year. I prefer the 18" thick mattresses; it's nicer than the thinner ones to sit on the edge of and put your shoes on, but if your tent is not tall enough, it can be claustrophobic. I tried a 24" thick one once, but I returned it as I liked the 18" one better. I carry mine in a good duffle bag which also fits my corded 12v pump and a hand pump. The 12v pump does not fill the bed as firm as I would like, so I top it up with the hand pump before going to bed. I think it is good to keep the price under $100 as it is too easy to puncture the bed with a cactus thorn that comes out of your boot. The beds are easy to patch, but finding the hole in the first place is the hard part.
Good luck, and I hope you are as satisfied with the air bed solution as I am.