Huckster - I've walked Wente, including the Lombardo St switchback. Really a terrible place to walk since they cut no walking paths off the tees through the waist deep grass ( I think hole twelve, a par 3) was particularly annoying. I've never been back.
Anyhoo... Not the longest walk between holes, but I once bet several players that they couldn't hit the 5th tee box from the edge of the 4th green at Poppy Ridge Chardonnay... It's all about club selection there. 4-iron is too little, driver is too much...
More random factoids: I once read that Steve Williams won money off of Tiger and Butch by touching the front of every tee box and green, running on foot on the back nine at Plantation Course in under 30 mins (he did it in 19mins...). Amazing little routing, and amazing how much knowledge the caddie has in his feet.