Anecdotes are weak evidence, but personal experience is the only thing that matters here. Scourge said, "I've tried it several times and found it unpleasant." It's not a myth that he felt like this.
Fwiw I too have never had a pleasant experience: never felt relaxed, never had the giggles, never got the munchies, etc. I'm not sure if I would call my experience paranoia, but I become anti-social and want to be left alone. What makes it worse is that I feel guilty for feeling this way when everyone else is socialiable. The only times I've had a different experience were when I decided to drink, too. Then, I feel violently ill on top of the extreme self-consciouness.