There are no psychotropic effects to absynth. The only feeling you will get from drinking it, is drunk. <seinfeld>not that there's anything wrong with that</seinfeld>. As bumbaclat mentioned, the rest is all hype.
If you are in Czech republic, you can get decent quality, inexpensive absynth. If you know someone there, you can have them send it to you for ~$20-30. To order it from Canada is very, very expensive because they know they can ripoff north american people seduced by the history of absynth. The same bottles I had here were selling on Czech websites for nearly $200US. They cost $24 in Czech.
You can buy absynth from the BC liquor board. It has 10 mg thujone/kg, but that doesn't matter, because thujone doesn't do anything anyways. "Hills" (the absynth available in BV) is high quality and well distilled absynth at a reasonable price (~$80 a bottle). It isn't terribly authentic because they have reduced the aniseed oil, to make it less stunningly licoricey tasting and more drinkable; this has the effect of making it not cloud up (louche). The Czech absynths, even though they contain more thujone, are generally cheap liquors and poorly distilled. I swear some of them are just vodka infusions of herbs; some have an off dull green colour, and none of the Czech absynths I've had have tasted quite as refined as the BC absynth, (except for King's), and few display the clouding effect. One czech absynth (name failing me... it was from pilz) tasted a lot like grass.
Anyways, if you've never had absynth before and are planning a night long session, bring some beers to back up the night, cause more likely than not, you won't want more than a glass or two.