More gimmick than magic. At best they can do a crappy job of emulating specific human behaviours on carefully curated training datasets.
Given enough time, energy, and computing power, you could just precompute every possible outcome and call it a neural network. You'll be praised as a genius.
Neural nets have been very successful for a lot of things while also being overhyped, but dismissing it all as marketing hype is throwing the baby out with the bathwater.
AFAIK we don't know how much of that generalizes.
...With better performance than human, that is pretty magical.