While I think holes like the one at Port Royal are certainly intimidating, it is not that hard to make a hole intimidating with that kind of link. There's a course around here with a 245 yard par 3 where you hit over wetlands, and basically short or right is in the wetlands, long is lost, and left is OB. Your bailout, as such, is to hit a bit short left of the green (forced carry of "only" 200) Obviously it plays much shorter from the other tees, but it is a hard hole for everyone.
Any hole with a 240 yard shot and some obvious trouble that awaits bad shots is going to be intimidating, because even players for whom 240 yards is only a 4 iron don't consider a hitting 240 yard shot square on the target to be automatic.
It's more difficult (and a more impressive feat) to make a shorter par 3 intimidating. Like TOC's Eden, or the picture Mike posted of Dismal's 5th (which from the regular tees is like a 9 iron, but you can pretty easily see what will happen if you don't catch it square)