I mean it's Google. You'd think they'd have nailed the concept of "searching" by now. :)

But I have found a weird workaround for this. After installing Google Drive File Stream locally and searching for things with the file explorer, it doesn't seem that bad all of a sudden.