What drugs need to be absorbed into the bloodstream to exert their desired effect?

Every drug. Wherever or however you take in drugs, it goes through the blood stream so that it can be transported around the body to wherever it is meant to go. same with food or water or air.