I've been playing around with it (oh, and they're trigger_cameras, not func_cameras
) and I've gotten it to work just the way I want in Spearhead. The camera pans around to where you can see yourself and slowly zooms out so that you can see two marines standing on either side of the tunnel, and the timing of Diabolical Adrenaline Guitar is great when it starts playing.