You do know that electricity, at least im countries with a power grid actually deserving that name, so maybe not the US, can be transmitted over quite long ditsances?

If I go to https://model.energy/ and ask it to find the optimal renewable + storage solution to provide a constant power output in New York state, the solution includes plenty of solar (and comes in cheaper than nuclear likely would). It also includes hydrogen though, so it would likely make sense to make some of that hydrogen elsewhere and send it to NY by pipeline.