At Old Head, when we looked at the project years ago, I actually saw a rock climber hammered in to what is now the 4th green, rappelling down the cliff face toward the ocean. You wouldn't want to fall there.
At Cape Kidnappers, the 15th fairway and 16th tee are the two spots where you could fall to your death [and you would have several seconds to think about it before you went splat]. Neither one is very obvious as you approach them; in fact, other spots LOOK more dangerous but there is another ledge below so you wouldn't have a problem. Of the two, the 15th hole concerned me more, because golf carts are loose in the fairway and a lapse in attention could get you in trouble faster that way. We did not want to put up a fence and spoil the view, but wound up deciding to put in a three-wire sheep fence, which is adequate to stop people while disappearing visually in photos etc.
Another factor at Cape Kidnappers is that it's an earthquake zone, so even standing close to the edge may one day be a case of very bad timing.
At one club where we consult, there were some trees up near the clubhouse, that one of the members didn't want us to cut down. But then another member mentioned that was where a member had been killed before when a tree limb fell on him in a windstorm! I was horrified that they hadn't taken down all of the trees around there, and got them to do so.
However, the three biggest causes of death on a golf course are not due to spectacular location. I don't know statistically what order they're in:
1. Lightning strikes
2. Trees falling (as documented above, and many other examples)
3. Getting hit by a ball in play
In the third category, due to a discussion here two or three years back, I did a quick Google search to try and figure out how often it happens, figuring most such instances would make the newspaper. I found about 1-2 examples per year. On the vast majority of them, the deceased was either (a) in the same group as the player who hit the shot, just wandering obliviously ahead, or (b) a maintenance worker who was close to the player but far enough off line that the player went ahead without thinking. [The Pasatiempo example, of a player being killed from a shot hit 150 yards away, is extremely rare because the ball speed is much less by that point.] Please, everyone, keep those two in mind when you play golf.