You listed a number of things that have been super hyped flashes in the pan that never really panned out (or in the case of self driving cars, have taken way longer to pan out than people expected), but you didn't list the things that were super hyped and then became big successful sectors.
I remember when I thought "web 2.0" was overhyped, but now it's just the water we all swim in. I remember when that went from blogs to being social media, and I thought that was way overhyped too, but it turns out it was a big deal. The cloud was overhyped, "big data" was overhyped, SaaS was overhyped.
And it's true that all of these were overhyped! But they also turned into real business sectors.
It's certainly difficult to predict which hype-y things are going to mature into sustainably large markets, and which are going to fade into obscurity, but a model of "things that are hyped are doomed" is not predictive.
My own prediction is that AI tools are both overhyped and also very promising. I have no illusions that this prediction could be totally wrong. And even if it's right, I'm even more uncertain what the successful business models are going to be after the dust settles. We'll see!