In this review we describe how highly addictive psychostimulants such as cocaine and methamphetamine actions might underlie hypoexcitabilty in frontal cortical areas observed in clinical and preclinical models of psychostimulant abuse. We discuss new mechanisms that describe how increments on synaptic dopamine release are linked to reduce calcium influx in both pre and postsynaptic compartments on medial PFC networks, therefore modulating synaptic integration and information. Sustained DA neuromodulation by addictive psychostimulants can “lock” frontal cortical networks in deficient states. On the other hand, other psychostimulants such as modafinil and methylphenidate are considered pharmacological neuroenhancement agents that are popular among healthy people seeking neuroenhancement. More clinical and preclinical research is needed to further clarify mechanisms of actions and physiological effects of cognitive enhancers which show an opposite pattern compared to chronic effect of addictive psychostimulants: they appear to increase cortical excitability. In conclusion, studies summarized here suggest that there is frontal cortex hypoactivity and deficient inhibitory control in drug-addicted individuals. Thus, additional research on physiological effects of cognitive enhancers like modafinil and methylphenidate seems necessary in order to expand current knowledge on mechanisms behind their therapeutic role in the treatment of addiction and other neuropsychiatric disorders.