Jeff,
I'm rather surprised that you seem to be saying that a hole is either penal or strategic, or strategic or heroic, to say nothing of all three!
I defy anyone to explain to me how #17 TOC isn't penal, strategic and heroic all at once. Its surely penal: the bunker, the road and wall, and the OB which is so penal everyone plays so far away from it that going OB on #17 is almost unheard of! I won't even defend strategic, if that hole doesn't qualify, nothing does. Certainly its heroic, as one may be as heroic (some may say foolhardy, but its all a matter of perpection and personal feelings exactly how penal the bunker and road are) as one wishes in attempting to play for the green or the pin itself.
Maybe there aren't a lot of REALLY GOOD examples of this, but the holes that qualify on all fronts are the ones everyone remembers, and the ones we discuss endlessly here on GCA. Holes that are merely strategic are interesting, but are rather easy to create and a dime a dozen as a result. Holes that are merely penal often aren't even all that interesting.