Your solution totally makes sense but it didn’t work for some reason. Now the first camera works as long as I’m inside its designated trigger volume and once I’m inside the second one, none of the cameras get rotated.
I’ve posted my BP on BlueprintUE, maybe the problem lies in the way I’ve set it all up.
Also, thank you for taking time out of your day to help people on here, it’s greatly appreciated! 