There is probably nothing weird about the discovery of LSD. But it is interesting that Hoffman had spontaneous mystical epxeriences in early childhood. He accidentally ingested a dose which lasted for about 2 hours or so. This is at odds with the care he took in his laboratory, dealing with what he utterly knew were toxic compounds, and the actual duration of LSD effects. He then experimented intentionally, but because of of his childhood experiences, he may have had some framework to contextualise what was ocurring to him. It was certainly fortuitous.
I just always found it odd that his accidental ingestion doesn't sound much like LSD intoxication, but more like a spontaneous mystical experience.