Hello Joe,
For dive sites near me there’s Canandaigua lake, we could also go north to Rochester and the great lakes, or even further north to the St Laurence River for some wreck diving near Clayton NY. I’d also be willing to venture down to PA if there are any easy/good sites. I know there are a few good quarries down your way.
Cheers,
james