Flashy new courses by name architects: The three at Turning Stone, Saratoga National, Seneca Hickory Stick, Harvest Hill, Diamond Hawk, Timber Banks (although Nicklaus never set foot on property, according to my never-to-be-named source), Mill Creek, Hiawatha, Ravenwood,
Old School Publics: Otesaga/Leatherstocking, Lafayette Hills (Syracuse), Chautauqua Ross, Mark Twain
Middle Age Publics: The Monster at Concord, Grossingers' Big G, Seven Oaks, Glen Oak
Homespun Newbies/Non-Name Architects: Links at Ivy Ridge, Greystone, Arrowhead, Conklin PC, Holiday Valley, Peek 'n Peak Upper, Chautauqua Hassenplug
And I could go far beyond the 25 courses listed here, as I don't have any from the Albany-South area. I have to agree with Matt Ward, that NY state public golf, especially upstate, pales in comparison to its private counterparts. Want as we might, upstate NY public golf is good to excellent, but never great.
Think of all the courses listed above...which ones are on "great" pieces of land, as defined by turf or topography? I don't think a one of them claims a great piece of turf; they are all farmland courses, not a one is sandy base. As far as topography goes, you have the hill courses (southwestern NY, Catskills, Adirondacks) the flat- and dryland courses and the flat- and wetland courses.
Now think about routing. Does any one of the old-school courses claim an inspired and perfect routing? I'd say no. Most of the courses above have at least 14 (but no more) excellent to great holes. This holds them back, and holds me back as well, from a top-five list. The hairs that need to be split to eliminate numbers six on down are too fine for me to hew, so I leave the selection process to those of you much better schooled in this type of course analysis than am I.
I will leave you with a bit of opinion, however. Timber Banks and Seneca Hickory Stick have some interesting golf holes and are excellent additions to the UNYS public realm; it is a shame that Walter J. Travis never designed intended public courses; Mark Twain deserves better administration, as does Durand-Eastman; Arrowhead could benefit from a longer set of championship tees (tips at 6700); nothing in the Catskills has any sense of subtlety nor humility; Michael Hurdzan's team shortchanged western New York when it came to the par three holes at Harvest Hill and Diamond Hawk (collectively, they are terrible), in stark contrast to the par fives and short par fours, which are brilliant; Paul Albanese and Scott Witter deserved to come along 10 years earlier than when they made their marks (Mill Creek and Holiday Valley; Deerwood, Arrowhead and Ironwood) in UNYS.