In my job I spend a fair amount of time with both smart people who are incredibly skeptical of AI and its potentials and other equally intelligent people who are wildly optimistic. One way I square this circle is accepting that we all tend to overestimate what can happen in the short term and underestimate what can be accomplished over the long run.
The use cases I'm most interested in are around creativity. People often talk about ideas that look like a button that makes a finished video and shares it on your behalf, but that's not what this looks like. People have taste and emotional resonance that AI can't replicate. Instead, for creators, AI will show up as series tools of tools that make it easier for more people to be more creative.