My home course has three sets of pads, red, blue, and black; I play the red (short) pads more often than the others. I haven't been able to get out on my own much lately, so most of my recent rounds have been in our weekly singles action on Monday nights, in the Rec division (I run both, but play Rec). For those, we alternate weeks between the reds and blues. The occasions when I've played Open, or when I've played in the Thursday night doubles action, are about the only times I've played from the black tees (Open plays blacks twice each month, red and blue once each the other two weeks of the month). Most of the better am and pro players prefer the long pads here since they're the only ones that are concrete (others are crushed stone).
Even though I've been playing a while, distance is still by far the weakest part of my game; when reaching the putting circle in 2 is still a challenge for me on some holes from the shorter pads, why would I want to belabor the point by adding another midrange/fairway driver shot on half the holes?
I suspect it's somewhat different for me than for others, since my home course is technical enough that just playing from the shorter pads doesn't guarantee a birdie or par on most holes -- there's not a lot of distance difference on the shortest holes, but on most holes there's a distinctly different look and set of challenges from each set of pads. There are certain holes where, given a choice, I'd rather play from the blue or black pads, because the lines available from the red pads are difficult to hit consistently, if at all. Take some of the distance out of the equation, and require a greater amount of skill in shot shaping and consistent execution on every hole, and you have a course anyone can enjoy whether they can throw 400'-500' or not (well, except the guys who can't do anything except throw 400'-500'.
There's another local course I play sometimes that's less technical (though still with enough technical shots to keep it interesting) that has two sets of pads and multiple pin locations on most holes -- when the pins are mostly in the shorter locations, several of the short tees are almost stupid-short (7 holes in the 145' to 160' range). Still mostly play the shorter tees there, and tend to play from the same tees for the whole round so that I can more effectively keep track of how I'm playing compared to previous rounds, but I've been tempted to back up to the longer pads on those holes at times.