Messing up the screen or controls is weak stuff, I want my virtual drugs to give me a proper trip.
For example. the
Walking with Spirits quest from the Point Lookout DLC from Fallout 3, where you get a psychedelic trip where you see, among other things, bobbleheads with cryptic messages, a giant bonesaw sawing through the ground and then the ground being stitched up with a giant needle and thread and the skeleton of your mother on the operating table she died on giving birth to your character.
Though I did like the mission in Far Cry 3 where you have to burn the weed fields. Standing in the smoke makes you high which does only distort your screen a bit, but I think it works really well.
I also think it's interesting to ask what the worst thing drugs/poison has done to enemies when used by the player. In Shadow of War, you can poison grog barrels found in orc camps. At first, this just kills any orc that drinks from it after a few seconds. However, after a few levels you can get a skill upgrade that lets enemies explode instead, spreading the poison effect to any nearby orcs. After a few more levels, you can get another upgrade that, instead of letting the orc explode, makes him attack other orcs while occasionally making him projectile vomit, spreading the effect to other orcs, before dying after a few seconds.