The troubleshooting you list here second is my primary use for a Google search and it is completely garbage. Just like you say, it’s a bunch of trash SEO sites that don’t really address the problem so most of the time I add reddit to the search to get legit answers. Because reddit has a garbage search engine, of course.
Though I have to admit I have given up on that and just use DDG to search for Reddit results. It used to be that I’d start on DDG and if it didn’t have what I need I’d go to Google, but Google search has gotten so bad that I almost never bother anymore.