Just talking about the medical effects, I've had trouble sleeping forever (like I can lay in bed a couple hours at night). Anyway, once I started smoking pot I can actually get to sleep (and sleep very soundly), even better than sleeping pills, which have always had very mixed results for me. It really is a shame that it's not at least available medically everywhere, as this thread just reinforces its bevy of uses in making human life better.
As far as stoner stories go, we live on the first floor of a three-story building. So one night I was out smoking on our patio and this guy walks up and is like "Hey man, smokin a little maryjane?" to which I replied "Yeah man". He goes on to tell me that he lives on the third floor and that they deal, so I got a new hookup. After our brief conversation he points to the railing and asks if I mind if he gets up there (I had no idea what he meant) to which I consented. He then hops up on the railing and climbs up the side of the building to get into his apartment through their patio. Weirdest thing that's ever happened to me out there.