OK, I've included a test mission with four sexp operations.
You start out in a Ulysees, nothing else in the mission.
Hit 1. The camera should move to position 0,0,0 facing straight ahead.
Hit 2. The camera should rotate to face the Ulysses.
Hit 3. The camera should rotate back to its starting position.
Hit 4. The view will return to in-cockpit.
Now, on any recent released build, on "2" the camera will reset to its original position once its done. I'm guessing it hasn't been working for anyone else because they confused the ms value with seconds, so the camera jerked to the destination position, then jerked back to the original position. This is a bug, and I just uploaded a fix to CVS.
You can hit 3 while 2 is still working. It's not really working that well right now, because the calculations don't take into account the time to change velocity; they assume a starting velocity of 0.
Note that the set-camera-facing-object SEXP will only face the position of the object when called, so if you move after pressing 2, the camera will not follow you.
Finally, the camera should still move regardless of whether its active or not. So if you hit 2, then wait a couple seconds and hit 1, you should catch the camera partway through its movement. It's setup this way so you can have multiple cameras at once (although the SEXP system is only set up to handle one.)