I find videos helpful for getting an overview or hyping me up to do the cool thing but once I need to do the cool thing articles are way better

Definitely agree! I do occasionally like videos as an accompaniment to an article to show something that is easier to show over text and static images. I prefer the ones with little to no speaking, and they're usually five minutes or less. (Bonus points if they have those little bookmarks on certain time intervals so you can jump back to a certain part easier.)