So many familiar holes mentioned here...
Aptos Seascape - oh man, Mike is right on re #13 (old #4). Skinny 460 yard par 5, raised tee hitting down into bowl-like valley, huge trees and jail left, heavy rough and ob right. Hole goes straight and then green is tucked in to the left, behind a giant tree, also behind a lake... Mike is right - one either finds the very right side of the fairway or goes wedge/wedge for shots 2 and 3. Interesting, strange golf hole, more hated than loved.
And Bill gives a great mention re Indian Valley #5 - a fave hole of mine, he describes it perfectly. Interesting also, it might be the poster-child hole for the "many golfers ignore strategy" thought that Dave M. doesn't seem to believe... Even in my group tournaments there, drivers outnumber irons off that tee easily 3-1, although driver is a patently stupid play. Don't ask how I know it's stupid from personal experience...
As for great tight golf holes, there are actually many on the great links of the UK and Ireland, but the tightness there comes from bunkers, not trees, so the "feel" is wider - even on a great tightly bunkered hole like 18 Muirfield.
Hmmmm.. a great tree-lined tight hole? How about the old version of #12 Bayonet - although I'm sure Adam will disagree.
TH