Lee - I'll offer a great hole: the 10th at Scioto in Columbus, Ohio, a Donald Ross design, where Jack Nicklaus learned the game. On paper, it's a straightaway par 4 of around 400 yards, maximum, probably 30 yards less from where I played it last year. Just one fairway bunker over on the right.
The genius of the hole was in its topography. It plays up and over a knob of a hill, with a fairway that cants left to right. From the left side of the fairway, a typical drive ends up blind from the green. (You can't drive it far enough to clear the hill. Well, Tiger could, but club members can't.) From the right side of the fairway, because of the slope of the hill, you can see part of the green. So the closer you position your drive next to the fairway bunker, the more visibility into the green. Simply but effective strategy. No bells, no whistles, no gorgeous backdrops or splashy bunkers. Doesn't even get much mention by Scioto members, who favor the uphill 2nd (Dan Jenkins' pick as Best 2nd hole in America back in 1965) or the par-5 8th or the par-3 17th. But often, the great holes are the simple ones. This, in my opinion, is one of them.