Show 1 single example of alcohol / drunkenness in the bible that had good results.
One can make the case that alcohol use is not a sin (debatable), but, alcohol does affect the mind, loosening inhibitions (morals) putting one in a position that facilitates sin. One should not facilitate sin.
Drunkeness is forbidden. But the use of alcohol is not forbidden, in fact it is spoken about in celebrations of the Lord, as a gift of God to man, and as use in medicinal ways. Examples of each, in turn, are below.
Deuteronomy 14:26
Use the silver to buy whatever you like: cattle, sheep, wine or other fermented drink, or anything you wish. Then you and your household shall eat there in the presence of the LORD your God and rejoice.
Psalms 104:14-15
He makes grass grow for the cattle, and plants for people to cultivate— bringing forth food from the earth: wine that gladdens human hearts, oil to make their faces shine, and bread that sustains their hearts.
2 Timothy 5:23
Stop drinking only water, and use a little wine because of your stomach and your frequent illnesses.
Wine is referenced throughout the Bible as an actual substance, so common that it is considered part of daily life.
(2 Chronicles 11:11
He strengthened their defenses and put commanders in them, with supplies of food, olive oil and wine
Ezra 6:9
Whatever is needed—young bulls, rams, male lambs for burnt offerings to the God of heaven, and wheat, salt, wine and olive oil, as requested by the priests in Jerusalem—must be given them daily without fail)
It is also used figuratively as the end result of life’s choices. It can be both good and bad, and is used symbolically in Jewish sacrifices. Wine is used as an offering to the Lord during the daily sacrifices.
(Exodus 29:38-41
This is what you are to offer on the altar regularly each day: two lambs a year old. Offer one in the morning and the other at twilight. With the first lamb offer a tenth of an ephah of the finest flour mixed with a quarter of a hin of oil from pressed olives, and a quarter of a hin of wine as a drink offering. Sacrifice the other lamb at twilight with the same grain offering and its drink offering as in the morning—a pleasing aroma, a food offering presented to the LORD.)
Wine and other fermented drinks are not forbidden by the Bible. Drunkeness is. Temperance and self-control are necessary for believers in all aspects of their lives.