The best I've played was the first hole at Tom Doak's now-dormant Aetna Springs. 360 yards from an elevated tee, the fairway was divided into three distinct sections (short left, middle right, long left) by a burn that cut across the fairway diagonally twice. This burn entered the fairway on the right side about 200 yards from the tee; players who could carry the ball 220 could either play to the left, where the fairway ran out at about 260, or to the right, where it ran out at 280. Because the front-right side of the green was protected by the burn and a tree (as at the 10th at Carnoustie), playing left ensured a safer angle of approach; the tradeoff was that in order to ensure you remained short of the burn, a prudent layup shot to the left would leave an approach of about 140, whereas you could have an approach of perhaps 80–100 by playing to the right. A third option for extremely long hitters (who probably visited Aetna Springs extremely rarely) would have been to attempt to carry the burn twice from the tee, requiring a carry of 290–300. Under firm summer conditions, the hole could have been drivable.
Doak repeated the same themes again at the par-5 8th. Here's hoping that Aetna is truly just dormant and not forever gone.
I also thought about nominating the 2nd at Keney Park, but the extreme left-to-right shot required to carry the creek takes the hole down a notch for me.