I know that in Wing Commander Saga's campaign, there's a strike mission against a Kilrathi heavy carrier battlegroup. As you get to the first Nav point, the CAG (Ranger) says "Anyone who wants to sleep, better do it now!" as the next nav point is quite a long way away if not using auto-pilot. Presumably the writers of that game assumed that pilots in the Wing Commander universe generally don't do a lot while the auto-pilot is on?
That mission then leads to a wonderfully frenetic fight between a large strike force that you're a bomber pilot in, up against a Bhantkara, 2 Fralthi IIs, a pair of light destroyers, and a whole pile of enemy fighters. It's a mission where the game's reliance on the Freespace engine starts to hurt as a bomber pilot, since the default turret logic only allows it to fire at whatever the player has targeted; your turret can't do anything while trying to get a torpedo lock!