Different types of alcohol, different effects?

Hello. I saw this on Joe Rogan and wondered if it was true. Rogan claims that different alcohol types have different effects on you. Like you are a different person when drunk depending on the type of alcohol you drank. He said that when he only drinks wine he feels very happy and joyous and sweet. Is this true? may someone give an example for each type if so?