Well, some people get pretty weird when they're stoned. Some of us, though, are completely normal, but we still enjoy being stoned. When I'm stoned, I'm a lot (A LOT) more calm, and shit. I can sit there and be silent, being completely absorbed in something much easier than I could sober. Example: When I go to my friend's place (also happens to be my source), we usually play Soul Calibur 2 stoned. I can play that game for an hour or more straight without barely saying anything. Not to mention I could care less if I win or loose, which is much different than when I'm sober (I hate losing).
Of course, it's not the same as being drunk. When you're drunk, how you act depends mostly on your perception of alcohol, and how people should act when drunk. If someone grows up thinking of alcohol as a big party thing, and going nuts and shit, they're going to more or less act that way every time they get drunk, but in places where the general view of alcohol is a way to relax, people tend to get more relaxed and less active. It's all about your mental views on it.
Being stoned is different, in that you know you're stoned, and you have a better idea of how stoned you are. You can think clearer when you're stoned.