Thanks very much for the info!
Turns out, what I had setup should have worked fine... but there was a script on the camera object that was preventing the camera from moving to the new transform.
This script is OrbitCam (which is used for orbiting the camera around an object). When this script is disabled on the camera, the camera properly switches between different transforms. When it is enabled, the camera won't move.
Thanks again.