As a former chronic smoker, the only negative thing I would say about weed is that it DEFINATELY ZAPPS MOTIVATION. Anybody that tells you different is out to lunch, IMHO.
Depends on the person....depends on the weed. Smoke a heavy indica and most likely you'll want to sleep. Smoke a cerebral sativa and its a whole different dealio.