No, actually it doesn't. You start with the automatic one that youtube creates and then edit it.
It takes about twice as long as watching the video (i.e. about 2 minutes for each minute of video).
Source: I've started doing this for videos I upload.
Yes, if your audio quality is bad, and youtube can't understand anything so you have to start from nothing it would be significant effort, as you say. But if your audio is clear, it's really not that hard.
If you want perfection (line breaks in logical places, not too much text at a time on the screen, captions synchronized perfectly with the speaker), the time goes up to about 4 or 5x, which is still not "significant effort".
This isn't really true, on YouTube it's basically a check box[1]. Admittedly the quality isn't always perfect but it's trivial and better than nothing.
Affine. Affine linear space, my friend.
Transcripts are useful beyond hearing-impaired people, but the cost realistically must be balanced with the organizations other responsibilities...