Great topic. The most memorable short drop shots I've played are Merion West and Leatherstocking. The "all or nothing" moment after the tee shot is something that golfers of all skill levels [IMO at least] can appreciate.
Another really fine one is #6 at Fieldstone in Delaware. That course doesn't generate a lot of discussion, but some very interesting holes.