At the end of the game, all player views can be interpolated to a shared ending camera (In Dota, this is to show the Ancient destruction.)
To get this behavior, add an 'prop_dynamic' entity named '@end_camera' to your map. (The '@' prefix prevents it from being renamed if it's in a prefab.)
If your model has an attachment point called "camera_attach" the camera will follow it, otherwise it will follow the position and orientation of the camera entity.
To more easily position your camera, consider the Hammer menu commands View > Align Active Camera to Selection (moves the Hammer camera to the selection) and View > Align Selection to Active Camera (moves the selected object to the Hammer camera). Note that the exact field of view may be different in Hammer from game, and different between players running with different video settings.