There's definitely a hype cycle in AI - - this is primarily a byproduct of marketing that coaxes investors to pay more attention to AI startups. This doesn't mean that AI is useless or "unlikeable". I'll assume that by AI you're talking about LLMs.
The best use case I've found for GPT models is RAG, which is LLM + querying a database for "grounding" the model in facts or internal company documentation. This isn't easy to do, takes a fair amount of work to prevent semantic drift and determine how much grounding information is appropriate...but good RAG pipelines + LLMs are something you'll want to check out, if the limitations of massive GPT models annoys you.
The other significant development has been tiny but highly performant models - - I love how good Phi-3 is, for example, especially in smaller contexts.
If you're upset that an AI tool can't make Apple or Android apps, at one level it's understandable, because many of these companies have been over-selling the abilities of their products, at another level it also means that you may need to look into how these models work, and although they can't do the work for you, you can probably find ways to use them to make you more efficient when you're coding your app.
Regarding the deterioration of the SERPs because of ChatGPT content, that does annoy me, but then I remind myself that before ChatGPT, we had deterioration of the SERPs due to spintax, which was pretty bad too. The writing style and tone that ChatGPT has been trained to use does grate on the nerves a little (especially the refusals) but IMO that itself is the result of anthropomizing it. If you treat it like a tool instead of a person, it's a lot easier to deal with.
SORA and other similar tools (Runway etc) will be useful for creating B-reels and stock footage. Don't expect it to create a movie from scratch, but it will be very useful for Youtube creators.
At a strategic level, LLMs are an amazing tool for generalists - - an LLM won't make you an expert in anything, but it cuts your learning curve by reducing the amount of research you have to do. Example: get 20 ebooks on your subject matter, throw them into ChromaDB or a vector store of your choice, slap an LLM in front of it and now you can "chat" with your books. So many problems can be reduced to search and sort problems, and I think of vector search as a great way to augment old-school search (TF-IDF and all that).
Just manage your expectations, and you'll find good use cases for LLMs. Don't expect them to "reason" they're not really built for that (I've kept an open mind about this, but after a year and a half of working with these things, IMO they simulate reasoning with token prediction but don't actually reason - - system 1 that imitates system 2) - - they're "just" prediction systems, but prediction systems can be extremely useful.