From Boldt Castle's tragic love story on a Saint Lawrence River island to a ruined Hudson River warehouse that hosts movie nights in the dark