Fine in moderation, too easy for me to get "addicted" and want to use it all the time.
When I exercise self-control, it's great. Nothing better than getting all my shit done for the day and then hitting the bowl and relaxing the rest of the evening, but it's too easy for me to hit the bowl first thing in the morning and then be completely unmotivated for the rest of the day.
Weed is...a sneaky drug. The fact that it doesn't kill you, or make you sell your parents' VCR, or suck dicks for it, is paradoxically the reason why it can be so insidious.
It lures you in as the one "safe" drug, the one drug you can consume infinitely and never really fuck your health. But it's really killing you in a different way. We all have limited time on this earth, so being consistently lazy and procrastinating regularly is, in a way, just a slow death. And no one is coming to intervene, you're pretty much just going to laze your life away with society's tacit approval.
Weed occasionally gives me bursts of insight or creativity or euphoria, so I keep coming back to it, but it just as often makes me feel lazy, dumb, and paranoid.
That's my experience, anyway. I'm on a break from it right now because my tolerance is too high, but I'm sure I'll be back. I'll come back to it in the coming weeks, reach a 6 from like the first hit, and it'll feel brand new again. That's where it starts; trying to recapture that novelty even though most of the time you don't.
That said, I find myself really thirsty for cigarettes (ex-smoker here) when I'm not smoking weed. I think Freud called this an oral fixation.
Weed can be really nice, but if you have the ADHD type of personality like mine where you feel the need to constantly fuck with your consciousness and find sobriety dull, it's kind of a burden at the same time.