What you need to do is, for yourself, break the problem right down into the little tasks, just write & test each mini-event within the script one by one, so that you can see how each of the different function works.
Quote: Player wakes up, coughing, looks around and passes out. (Not controllable, actions are scripted)
Initially you need to have a timer that is going to set off this particular event (only after the credit sequence is over)
If you logically break down a sequence from that quoted line, the first thing that needs to happen is removing control (SetPlayerActive), because at any point interaction from the player will stop it from working right.
Next up is actually waking up - initially just use FadeIn, you can come back to add other things like screen effects to spice it up once you've got the structure sorted.
For the coughing, if you already have the sound file ready then use PlaySoundAtEntity.
If you want the coughing to happen before the player looks around, then take note of how long the sound file plays for, because you'll need to use another timer to separate the events in the script
For the looking, you'll need to set up a couple of Script Areas in the map itself, and place them at the points you want the character to look at, then use StartPlayerLookAt to make them look at each point (once the player look at is complete, it calls another function - use that to set up the second Player Look At). Make sure to use StopPlayerLookAt at some point later in the script so that the player can look away from that area again.
Honestly, if you are quite early on with developing your mod I would
recommend you leave this whole intro sequence till towards the end -
it's probably one of the more complicated sequences that you'll need to do and you would
benefit from having knowledge gained doing simpler events first.
Additionally, there are sh*t loads of previous times when people have asked for help doing wake up scripts, various tutorials on the wiki & threads are available if you would like to search for them