Camera follows path, but is not looking the direction I want
If you use a Follow Path constraint, you can simply enable the Follow Curve option, and the camera orientation should follow the curve. In that case deactivate the Clamp To constraint. If you don't want to use a Follow Path, just keyframe the camera rotation.