As much as I’d love to, it is still one of the best places to read up on recommendations for stuff, be it hardware opinions or obscure book recommendations. It is certainly a better place for tech reviews than most of the other sites you find using search engines which just do stuff like “This is the best on a budget. This is the best for that. This is the best overall. Here is where you can buy all of that.”
Those sites never feel like they do a genuine review of stuff but instead try to sell you something. Plus they feel like they are copy pasting from each other.
I always try yt-dlp first with the website URL. If that doesn’t work I either try the URL shown in the network tab in the debug menu or try to find a video source URL by inspecting the video html container.
Once I’ve found a URL using one of those methods I again throw it at yt-dlp