>never seen a single person who truly "understand the technology perfectly well" say it's underwhelming

I'd say I've noticed an inverse correlation - people who don't understand the technology see it as this amazing thing, the kind of people who know their hash functions are a bit skeptical.