Mac,
Most of the best "pond" holes that I've seen do tend to be on Pete Dye courses. Personally, I think #3, #5, #13, and possibly #18
are just as good or better holes than #17 at The Golf Club, although its certainly not bad.
You aren't a big fan of Sawgrass, but #4, 9, 11, 16, 17, and 18 are good holes that have ponds. At The Honors Course, it might be more of a lake, but #9 and #15 are both excellent. Harbour Town and Long Cove both have a couple good ones, and #6 at Crooked Stick is a good par three as well.
In terms of other holes, I like #12 at Muirfield Village, #2 at Peachtree, #10 at Castle Pines, and quite a few holes at Victoria National. For a course in a fairly dry climate, I think the ponds at Paa-Ko Ridge on #9, 15, and 16 all work. I think they work better for having three of them--if they only had one I think the solo pond would come across as a bit strange.
The worst ponds tend to be on flat courses where it tends to be obvious that the pond was dug out (and usually the fill was placed to create mounding and/or build up tees). I think this is fairly understandable in Florida given the water table, but in the midwest it often looks artificial.