My home course, a restored/renovated Ross currently has ~1,070 yards total of the 17 green to tee walks (63 yards average), including 3 of above 100 yards each (110, 145, 175). I found it interesting that the original routing (different clubhouse location, different order, 2 holes that were replaced) came in over 300 yards shorter, for a 45 yard average, with only 2 above 100 (110, 120). In between is the original hole order, with the 2 new holes included, and that comes in just under 900 yards, or 53 yard average.
I believe Mid Pines comes in at just over 600 yards total, with an average of 36-38 yards per hole. Among courses in the US, I can't imagine too many would get much lower than this, but I'd be interested to hear.