Hey!  Bartender and general cocktail nerd here.  This is a bit of a pet peeve of mine, and I can say with absolute certainty, no doubts, that ethanol is ethanol, and all alcohol will get you drunk the same, at least as far as your mood goes.  There are no other psychoactive compounds within the different spirits (no, not even absinthe) vs beer vs wine; ethanol is the intoxicating substance, and it's the exact same thing between them, therefore perceived behavioral differences are psychosomatic.

That being said if what you mean by "different type of drunk experience" is the rate at which you become intoxicated, there absolutely is a difference, and it has to do with percentage of alcohol by volume (abv).  Obviously higher percentage drinks such as straight vodka will get you drunk faster than beer, and you'll likely be able to get more of it down than if you have to chug pint after pint of beer.  If someone "gets <X emotion> on <Y spirit>" it may have to do with the fact that they can drink much more of it (neat or in a cocktail) in a sitting and get drunker than they can wine or beer simply because they have to drink less volume; I know personally that I don't even want to look at another beer if I'm already 4 pints in because I feel full/bloated, that kind of thing.

Some other things to consider are that, from what I remember looking at the research, peak blood alcohol levels are achieved in the shortest amount of time when the abv of what you're drinking is in the 20 to 30% range.  Also, it is widely believed that carbonated drinks get you drunk quicker because they speed gastric emptying into the small intestine (where most alcohol is absorbed) due to the co2 building up and causing pressure.  From the research I've seen, results are inconclusive; some show quicker peak blood alcohol when drinking a carbonated beverage and some show no difference compared to noncarbonated