James Morgan,
I believe the current 18th hole at Plainfield was originally # 15 or # 16.
Drama and pressure come to mind when I think of a very good finishing hole.
Like obscenity, I may not be able to define a good to great home hole, but, I know it when I see it.
# 18 at Sebonack, NGLA, Shinnecock, Merion, Pebble Beach, Seminole, Pine Tree, Boca Rio, Pine Valley, Riviera and others come to mind.