Mark, take note that Bethpage Black is aerating their greens in the beginning of October. I believe that the Red will be at least one month post aeration by the time of your anticipated trip.
I played the Black last week while in NY and can only say that I hope the greens improve after them getting stressed during the Barclays. Close to half of the greens had dirty bald areas. The locals which I played with attributed the poor greens conditions it to a fungus infection.
I would hit Mike up on his kind offer to get on Yale. You can always get to Bethpage, parking issues aside. ; )