David,
I DON'T agree with Jaka B that you are so wrong....It just depends on what you think is important....
In theory, multiple tees allow the same strategy on each hole, presuming players pick a tee that relatively matches their tee shot distance and the distance to the fairway landing area/hazards. Of course, this still leaves the shorter players in the landing area, but with a longer club to the green, if everyone plays a good tee shot.
You seemed to indicate a concern for aesthetics, and I hear complaints about a hole being "all tee and no fairway" frequently! What Fazio does right is to stagger them and hide them. Then, in most cases, you feel as if you are on "the only tee" much like older courses with fewer tee boxes.
The ones I have seen don't stagger so much as to create a completely different hole for the forward tees, but I am biased to think a 5 degree angle difference wouldn't make much difference to average players frequenting these tees....
Quoting myself, "Assuming you believe that multiple tees are necessary, which I do, then this is a good example of how you get something - better aesthetics - when you give something, like land." So, I agree that it takes more land, and puts some tees farther from the previous green in many cases. (But perhaps not if the holes run 90 degrees from each other)
I'm not sure if one player struggling mightily from the wrong tee is any more or less condusive to a social round of golf. However, the situation you describe with three males is common in mixed male/female foursomes, no? Perhaps it slows play, as does the extra distance and cart usage.
Your solution of going back to fewer tees is okay, but probably worked better in the old days when:
The distance difference among players was 25-50 yards, and not 125-150 yards as it seems to be right now,
No one really cared about women, juniors, and seniors anyway,
and everyone walked, which is not the case today.
And, as pointed out, there are many holes where a variation in length can make a hole play distinctly differently, or allow the superintendent to place tee markers to make the hole play as usual in out of season conditions....
So, you give something to get something. What Fazio does is take the givens, (i.e. the need for multiple tees at many courses today) and try to mitigate the negatives (seeing too much tee) through clever design, accepting some other, less important negatives (i.e. use of carts, which could also be considered a given in most locales)
If and when things turn - either in general or at a specific course - like more walking, distance control, good designers like Fazio will take those criteria and come up with new designs that address those conditions. Right now, his tees address how courses currently play very well.