I like what Goanaut has to say... it's very true, what you get out of psychedelics has 1000% to do with how you view psychedelics. There are people who have done acid several hundreds of times just as a means of getting fucked up, and, ironically enough, they generally come across to me as very fucked up individuals. But then again, there are people who have done it thousands of times, and they respected it, never took it as a means of 'getting fucked up' and actually had intention behind all of their acid trips, and I generally view these people as sane, somewhat enlightened individuals. But it's not the drug that really causes people to become enlightened or fucked up. Acid just simply amplifies that which we are comprised of at the core. Many people are just naturally going through life looking for education, enlightenment, and awareness, in any way they can. These people tend to not just take acid... they meditate, they study many different ideoligies, they philosophize... their whole life, pre- and post- acid, has been about gaining awareness.
But on the other hand there are people whose lives are all about escaping, and just getting fucked up in any way they can. These people don't look for enlightenment in an acid trip, just like they don't look for meaning in a Cohen Brothers film. And these are also the people who refer to acid has having 'permafried' their brains, when they've only done it like 50 times. I've done acid 50 times in one year alone, and you won't hear me ever referring to an acid trip as being 'fried.'
So basically, acid is a very magical compound that has the ability to be exactly what the user expects it to be. Manson used it as a means to control his harem of women. Leary used it to come up with fantastical, whimsical ideas. Huxley used it to intellectualize and write. The options are endless.
I would basically say that LSD is exactly the way you think it is... and that's why.