The word "wine" in the bible can mean either alcoholic wine or non-alcoholic wine, depending on the context. You see scriptures condemning the drink that "bites like a serpent" (Prov. 23:32), and also scriptures such as the "new wine" that is "found in the cluster" (Isa. 65:8) which in that context implies that the wine referred to is not fermented.
I don't believe Christ changed water into alcoholic wine. The weddings in those days tended to last 2-3 days or so. Does it fit the character of God to create gallons and gallons of alcohol for a 3-day binge? Just like today's weddings, I hardly think everyone there would've 'drunk in moderation'. Not to mention wine tends to have more alcohol in it than beer, so there's the potential to get drunk quicker. I can't imagine Jesus' first miracle on earth was to promote an alcoholic binge which I'm sure fights, arguments, and drunken behaviour would've ensued by at least a few of the patrons.
What would Jesus say to those patrons that had too much to drink? "Well, you should've drunk responsibly. All things in moderation." Would He really create the best wine they've ever tasted, then condemn them when they drink too much? That's almost tempting them, and James 1:13 says God does not tempt anyone. Why would Jesus promote something that is warned about some 60 times in the Old Testament?
Let's take an even closer look. The master of the feast compliments the servants and says that most people start with the good wine, and "when the guests have well drunk" (John 2:10), then the inferior wine comes. But "you have kept the good wine until now!". So Jesus waits until everyone is "well drunk" and then caps off the party with the best alcoholic wine ever? Was there anyone left standing?
That doesn't ring true with my perspective of a righteous God, who says "be holy, for I am holy" (I Peter 1:16), and a God who gives good gifts to His children (Luke 11:13).
Now, I don't believe having a drink is a sin per se, although drunkenness clearly is (I Cor. 6:10) But why walk the line like a tight-rope? I'd rather try to "abstain from every appearance of evil" (I Thes. 5:22) and stay as far away from the line as possible.
What's the real reason many drink alcohol? To relax or to not be so uptight? Isn't that the slow effect of losing one's sobriety? We're called to be sober-minded and have self-control. Not allowing our minds to be given over to another influence, which causes us to speak or act foolishly. Which can still happen even when we're not fully drunk.