> The reason this happens is because the Google result shows my words in the excerpt, but when I click in, there's zero percent of the content to be found.
I’ve seen this too, but I’ve always assumed it has to do with meta tags or something.
No, it's due to illegal SEO practices where they serve Googlebot a plate of GPT3 meets keyword spam, and then serve you a page full of advertising and phishing links.