I think the impacts at some of the beaches will be pretty bad-days of onshore flow pushing water in before the main event and full moon Saturday to boot.
Hard to say for the city proper. But we're having east/northeast winds right now which is piling up water so I would think moderate at least for LI/CT/NJ coasts