According to Mapquest, Lake Sunapee is over a 5-hour drive from Manhattan. That's a bit much to drive for a one day event--even for me.
The last few years, I've gone up to Syracuse, NY (4.5 hours) for a 2 day, 3-stage, stage race called the Tour de Syracuse and will this weekend too. I didn't put in on the "must-race" thread because it's a small event, but I've always enjoyed myself up there. The wife and I combine this weekend with a little family visiting, so it's always worth the trip even though it's on the far side.
Looks like there are other closer options to consider this weekend though. PA is hosting a master's RR championships that is about 2 hours 45 minute drive. Another PA road race about 3 hours away in Oxford, PA.
Plus there are TWO Kissena Cycling Club events. Saturday there's a race in FBF, made a little more interesting by a prize list supplemented by cases of WINE! And the Tour de Parc in Long Island is a really tough criterium that I've enjoyed doing in the past.
I guess, what I'm saying is that if one was dying to do a RR out of town, I'd head to PA.
I once went to Whiteface in a friend's (Hank Schiffman) car. We raced up Whiteface at 5 pm or so. Medals ceremony. BBQ dinner. Then he drove back to NYC. Left me in Queens close to 2 am, left another racer in Manhattan, went home, slept 3 hours and finished 2nd in a CP running race (in his age group) at 8 am.... But I agree with you.