The cool thing is you can just try it. The barrier to entry is incredibly low right now. If it works for you, great. If it doesn't work for you, great. At least you know.
But most hype is not delusion. It's people trying to present themselves as "AI" experts in order to land those well paid "AI" positions. I don't think they even believe what they're saying.