I would suggest that a set target transform without any curves workes just like that.
I used the director camera as a target and in the first frame my character looks into the camera, but after that, it tries to look at the position where the camera was when the lookat-clip started.
carpe denius
