closest thing ive ever had to a recreational high on a ride is them gerstlauer sky fly's, if you get spinning you get a really good headrush which is similar to being many many pints down after a decent night out.
i wouldnt say ive ever been on a ride thats even remotely near anything else though. a weed coaster. pff. maybe a wacky worm? the only others that come to mind are baa express and alice in wonderland which are just a tiny bit like really odd psychidelic trips.
wild mouse coasters are good first coasters i think. tight corners, nice little pops of air time, and not remotely similar to any sort of recreational substance, just an abusive parent.