Jeff - it's a shame, but not too surprising, that when you ask golfer-types what hole we like best we come back with the ones we liked least. I think you may be giving us too much credit even in asking the question!
When I think of the course I play most often, there are two types of holes that stand out for me:
a) the 2 holes that have, relatively speaking, really good/interesting/challenging greens (one a Pinehurst-style upside-down bowl; the other an-almost Redan type green fronted by water), and
b) the 2 hardest-ranked holes on the course: a long dog-leg left Par 4, and a Par 5 with a creek that meanders down the right side and then crosses the fairway at about 180 yards out.
With a), besides the simple fun and challenge of putting good greens, I also feel like I'm "getting my money's worth", i.e. that the real work (trying to do no worse than a two-putt) gets started only when I think the work (trying to hit the greens in regulation, and in a decent position) has been done.
With b) I like them not because (or only because) they are stern tests, but because they play differently almost every day and are designed to allow for this -- a rare characteristic on this course. With differing winds and differing quality of shots, I can be coming into the Par 4 with anything from a 7 iron to a 5 wood; and on the Par 5, with a good tee shot I can hit my second to within 60 yards of the green, while after a poor tee shot I have to lay up short of the creek and still have a 4 iron for my third.
Those kinds of "correlations", i.e. between wind/shot conditions and choices, are very appealing when the design allows for meaningful and differing engagement -- and for an average golfer it is very satisfying when, after making smart choices and hitting decent shots, you manage to make par on the two hardest holes on the course.
Peter