> whenever I search for 'how to do X?' there is a lot of video results for sometimes very trivial things

You can usually pull the transcript/subtitles, without watching the video.