It depends. For many people codeine tends to make them drowsy. For others, it can give "energy". Also, if you take more than the indicated dosage of codeine it may cause insomnia.
In America and most countries, none do. In the US, codeine is a controlled substance that can only be administered by prescription.Actually your answer is not correct. Cough syrup containing codeine...