[US] I'm trying to think of common cases where a judge is the one declaring guilt that would warrant a massively expensive lawyer.

You have informal hearings on things like traffic court where the judges decide, but really a cheap lawyer that specializes in traffic stuff will have a decent chance of getting a ticket reduced. Probably because the lawyer is willing to make reasonable asks to the prosecutor rather than the judge for a reduction and the judge just signs off. Technically still pleading guilty and being found guilty, just of something lesser. People who represent themselves in traffic court seem to want to go straight to the judge rather than negotiate with the prosecutor and when the usually lame story gets told they get found guilty.

For criminal cases, normally it is a jury deciding. Expensive lawyers can put on a good show and do more research but the decision of guilt ultimately goes to the jury not the judge. I guess you could sub in a jury for the judge in the comic and I'd see it a little more. Expensive teams can also sift through for details such as what happened in the Alec Baldwin case to find something that got the case rightfully thrown out. The judge did that but it was less declaring not guilty as it was throwing out the case based on prosecutor misconduct.

People can ask for a bench trial, but unless somebody can point to a connection between a bench trial, expensive lawyers, and getting a higher not guilty rate I don't see it. It does seem, merely anecdotally, that pro se defendants seem to move for bench trials more than represented defendants, and they tend to lose. That seems less about expensive lawyer and more about having no lawyer at all and then just verbally farting in court until the verdict.

Civil cases don't have "guilty" or "not guilty" outcomes.

From what I've perceive of the average everyday non-sensational case, a public defender or a reasonably priced lawyer can do the job. The biggest hurdle is a combination of defendants' inability to shut up to the cops and court, and if there is other damning evidence the stubbornness of a defendant to take a reasonable deal and insisting on going to trial with bad facts against them.

Anyway too much dissection of silly internet comic.