I'd say I'm pretty close to "an average pickup buyer" with my driving habits lately. In September of last year, I bought a 2018 Sierra 1500 4x4. 2018 was the last model year the 2-speed transfer case was standard in the 1500. I did not buy the truck with the intention of any challenging off road use. I wanted a 4x4 to deal with snow, and the ability to move a trailer in low traction situations like mud and sand without worry.
In about 10 months, I've used 4L twice. The first time was simply to verify that it worked. The second time was when backing up my trailer, to get it out of a tricky situation. Could I have made the same maneuver in high range? Yes. Was it nice to have the extra control of low range? Yes.
Many have commented about how low the first gear is in current 8 and 10 speed transmissions, but what about reverse? With the V8 in my Sierra, I think I have enough torque, that I could probably get buy without 4L, and have it never be a serious problem, since my trailer is not very heavy. However, I do remember a time with my old I5 Canyon, where I was trying to back up my trailer over a rock, and in high range, I could put my foot to the floor, and it did not want to climb over the rock. I also remember lots of fun trail runs in the old Canyon where I enjoyed 4L. But, as we all know, most people don't take their pickup trucks on challenging trails, just for the fun of it.
Oh, and on the topic of 4 auto. There was exactly one time I wished I had it in my old truck. I was on a long drive through farm country on secondary highways. There was intermittent snow drifts over the road. They were fairly deep in spots. It was bare pavement - snow drift - bare pavement - repeat. In my new truck, I used 4 auto a few times last winter, since it was there. But, for many situations, I still preferred to maunally select 2H or 4H. It is nice to put it in 4 auto if somebody else is driving my truck, and they are not familiar with part time 4x4 systems. Rather than explaining when to, and when not to use 4H, you can just say, "I put it in auto, don't worry about it."