It's just personal, varies from person to person. I used to be able to get decent sleep with foamers, not anymore. Saving two or three ounces in my pad setup is asinine IMO, especially if it means I'm losing sleep, which does me no good the next day hiking a 10 hour day. I've switched to a lightweight full length synthetic inflatable and I'm never going back, unless it's just a SUL overnight or something and weight, simplicity, and maximum time on my feet is the goal.
Inflatable pads are extremely light now, 9oz. full length inflatables aren't uncommon, 10-14oz. full length insulated pads are easily found if you're looking for one. I always use a polycro groundsheet and clear my site before using my pad, I also only get on the thing when it's time to crash. An inflatable with a 70D bottom shell is more durable, might help with the leak and puncture problems.