There are two that spring quickly to mind at my home courses, Kittyhawk GC, in Dayton, OH.
Falcon, No. 11. This stupid hole is 256 yards and that's roughly 25 yards longer than my best drives ever go. It's a par-save at best before I even tee it up. Plus, if I get the idea to cream the ball, there is OB with the Eagle course on the left side.
Eagle, No. 8. I call this the "Moat Hole". I'm not sure a single hole has caused my more pain over the years. It's a pretty mundane-sounding 150 yards, but has a massive hazard that covers the entire front three sides. For what-ever reason, I hook my tee shot into the left portion of the hazard nearly 75% of the time. Plus, if the wind is up, it's straight in your face on this hole. Lots of rounds on this course tend to come off the rails right here.
I'm painfully short, but on one scorching August day the fairways at Kittyhawk were harder than Wagoner Ford Rd. on the other side of the fence. I hit a perfectly adequate drive on No. 7 of the Eagle course and watched the ball hop, skip and roll straight down the middle. For the first time before or since, I hit a PW to that green and birdied it. So I'd estimate about 290 total, but probably only 230 carry.
If players were allowed to repair spike marks then some would state that every perceived imperfection on a putting green was an "old" spike mark and tap them down on their line of putt: (a) giving them a advantage, and (b) significantly slowing up play. The spike mark solution is simple: (1) After you putt out, tap down all spike marks in the vicinity of the hole so that all of the following groups won't have any interference by them. (2) Pick up your feet.