If you're looking for a high, zolpidem can be good. It can definitely turn a boring night in, into something somewhat fun. However, you're looking for an alprazolam-like high, and I'm sure everyone on here will tell you that these drugs have very little in common.
I don't know how you define "trippyness", but speaking from my own lexicon I'd say zolpidem has some trippy qualities, but I wouldn't compare the high at all to LSD or Mushrooms. It's a lot less coherent (I'm usually taking doses of ~60mg). If you're into snorting things, it can be done with this substance. Zolpidem is more soluble in water than any benzos are (Don't quote me on this guys, this is from memory). I prefer taking it though, just because it hits you within 15 mins of swallowing as long as your stomach is somewhat empty.
Long in a short guy, don't plan on using your zolpidem for anti-anxiety purposes. Maybe short term, like getting fucked up on them when you have a really bad day, but nothing more. Just like how alprazolam is, you might do some fucked up shit on ambien.
There's not really a sweet-spot for making it like xanax. If you're like most people, 10mgs will make you want to go to sleep bad, and anything above that threshold will really start messing with you. Not a totally bad find though, save em for a rainy day, or use them if you have legitimate insomnia issues.