It looks like the other reviewers have done a good job of giving this album the respect it deserves. I doubt I will be as succinct and lucid as some of them, but I felt I just had to add my tribute.
I have a long history with this record. It started back in 2002 when I went to Amsterdam with some friends and took this record with me. The whole group of us just fell in love with it instantly, and would happily sing along in our mashed up states. These songs are so beautiful that some of them make me physically ache when I listen to them - "In the Morning of the Magicians" particularly.
"Do You Realise" was partially responsible for me getting together with my girlfriend. It's now "our song". I dount many couples have a "song" as cool as ours.
Not long after my girlfriend and I got together, we ate some magic mushrooms and had a bad trip. I had a particularly bad one as I'd taken 6 and a half times more than the recommended dose. While flailing around in the depths of despair and insanity I was listening mostly to the Screaming Trees' "Dust", which I used to like; but perhaps not surprisingly I haven't listened to since. Anyway, as the effects of the mushrooms lessened, and I started to realise that I wasn't dead or insane, I put this album on. Not only did everything get better, with the room starting to glow reassuringly, but Wayne Coyne's lyrics seemed to explain to me everything that I'd been going through, and everything I was then experiencing. It was a beautiful moment, and it helped to make the whole experience both the most terrifying experience of my entire life, and the most enlightening and worthwhile.
Perhaps that sounds sad to you, but I assure you that I feel enriched because of it, and wouldn't change a thing.
I am listening to this record now. I'm at work. On Fridays I always bring a selection of CDs with me, and today I brought Yoshimi, and it is tapping into my emotions and psyche as potently as it did when it was new. I just never tire of this record.