I always carry a spare tube and a pump, but that hasn't stopped me from becoming stranded. When I was at my largest (275-300 pound range), I pinch-flatted a lot. Twice I pinch-flatted myself plumb out of spare tubes. One time I walked the bike home (about 3 miles). Luckily I was wearing MTB shoes.
The other time I wasn't so fortunate. I started walking home (a distance of about a mile and a half) in stiff road shoes equipped with Speedplay cleats. Within half a mile, my heels were so painfully blistered I couldn't walk another step. My wife was at work, so I called my mother-in-law (who had a van and lived on the same street as me) to come rescue me. Fortunately, she was at home and was happy to retrieve me.
I now wear SPD cleats and MTB shoes exclusively, even when riding my road bikes. I also put tires with stiffer sidewalls on both road bikes and the gravel grinder. And when I ride the grinder, I carry two spare tubes and two CO2 cartridges in the rack trunk as well as a full-sized Zefal frame pump.