First, you need to figure out what aspect of behavior you're interested in. Then, you need to figure out which procedures are used by psychologists to measure those behaviors. When you know that, you should do searches for (drug name) and (name of behavioral paradigm).
Is the drug rewarding? You might want to know about conditioned place preference and intracranial self stimulation thresholds.
Is the drug stimulating? You might want to know about locomotor activity in an open field, which can also tell you something about anxiety.
If you want to know about anxiety in particular, maybe look for elevated plus maze papers.
If you're interested in various aspects of addiction, you might look for locomotor sensitization papers, self-administration and reinstatement, progressive ratio schedules, etc.
What about cognition? Some standard tasks are radial arm mazes, T-maze delayed alternation, delayed nonmatching to sample, novel object recognition, the 5-choice serial reaction time task, reversal learning, attentional set shifting, etc.
pubmed.com is the place to look for this kind of information. Each drug has a certain mechanism of action. Often, but not always, this involves mimicking or blocking a natural chemical at a receptor. A drug that mimics a natural chemical at a receptor is an agonist. A drug that blocks the natural chemical is an antagonist. If you are interested in THC, it's helpful to know that THC is an agonist at the "CB1 receptor." Researchers often use laboratory drugs that do the same thing as "drugs of abuse," but are easier to work with because they're not scheduled. For example, WIN 55,212-2 is often used in place of THC.
You can also get some insight by reading about what drugs with opposite mechanisms as drugs of abuse do. For example, SR141716A ("rimonabant") is an antagonist at the CB1 receptor. It reduces appetite, which is like the "anti-munchies."
At first, it may seem like the animal behavior paradigms are too simple to be really interesting, but I think we give humans too much credit. If you put infrared beams at regular intervals in someone's apartment, they'd move around more and break more of the beams after taking a stimulant, just like a rat or mouse.
