Senior curator Eleanor Harvey on why the cathedral has been beloved by American artists for years