I will concur with Bob H. on Princeville (Prince)'s opener as being sheerly intimidating, even with a 3-wood in hand off the tee.
Koolau's opener is tough, and though it is long, 3-wood unfortunately is the play off the tee due to bunkering and pinched fairways further out.
My vote has to go to my club's opening hole, though. #1 at Wake Forest GC in WF, NC, is a 711 yard par 5. The drive is 300 yards downhill, but the final 150 is straight uphill. The drive has trees on both sides, with lateral hazards way right, so spraying isn't good. Even if you hit a good drive, most will have to lay up with a mid-to-long iron, because of the creek that crosses at 200 yards from the green. This is actually why it is not a good hole from the tips, the forced layup on a brutally long hole. Take out the creek, and it isn't so bad.
Then you have 200+ way uphill to a difficult, two-tiered green, with a bunker front left and another on the right side of the green. From 150 in, O.B. is way right, but gets closer in the closer to the green you go. Doesn't help that the cartpath is on the right side for any pushed/sliced approaches.
Yes, it is the #1 handicap hole. Par is terrific from the tips, and my one birdie ever from there is one of my highlights. 3-wood from 215 (way uphill), one-putt.
The hole is much better from the next up tees, at 622 yards. A decent drive (downhill still) leaves a good chance to clear the creek with a mid-to-long iron, leaving approxiamtely 150 uphill yards in.