Check out the Marsh Chapel Experiment,[1] "Varieties of Psychedelic Experience",[2] the "Psychedelics Encyclopedia",[3] and Erowid's trip reports[4] for examples of people who did have massively transformative experiences.
That said, from what I've read, it's relatively rare for LSD to radically transformative in the long run (for various, psychologically interesting reasons). However, short-term transformation is relatively common, given a high enough dose and the proper set and setting.
[1] - https://en.wikipedia.org/wiki/Marsh_Chapel_Experiment
[2] - http://www.amazon.com/Varieties-Psychedelic-Experience-Class...
[3] - http://www.amazon.com/Psychedelics-Encyclopedia-Peter-Staffo...
[4] - https://www.erowid.org/
And at less than 30 quid, that's cheaper than 3 packs of cigs and a damn sight more interesting.