When I have smoked a joint in the beginning of the evening after work, I sometimes fall asleep on the couch for just a couple of minutes. It TOTALLY kills the buzz I had and I wake up disoriented and agitated.
As for smoking before going to bed, I think it's an amazing way to fall asleep...