Endocannabinoid System and Psychiatry: In Search of a Neurobiological Basis for Detrimental and Potential Therapeutic Effects