In my mind talking about wine and drunkeness are two seperate conversations. Getting drunk on wine is the last thing you want to do. The hangover is so strong that you quickly realize that there are much better things for intoxication. Wine is all about one or two tasty glasses with dinner or after that have beautiful flavor and just lead to a happy drowsy state.
I have mentioned Oregon Pinot Noir, Northwestern US Riesling, Amarone and some California Zinfandel (old vines are best). Some other good choices that will not leave one much poorer are the reds of the Southern Rhone in France (Chateauneuf-du-Pape, Gigondas and some Cote du Rhones), Rioja (which can be expensive but isn't always) and old vine Granache from Spain (which is always dirt cheap and often very good), Oregon Pinot Gris, California Sauvignon Blanc (the US's two best whites for the money along with Riesling), Sancerre, the best reds from Langudoc in France and many bottles from Australia, NZ, South Africa, Chile and Argentina. And always: good Chablis and Alsatian riesling, gewertztraminer, pinot gris and pinot blanc; also Zamo e Zamo pinot grigio (pinot gris in Italian). There are others.
And though they are not cheap I also love the red wines of the Nebbiolo grape from Piemonte in Northern Italy (Barolo, Barbaresco and Gattinara).
I still maintain that I am not a snob but one of the best aspects of my job is that I get to taste a dozen or two new wines every Wednesday. I swish and spit but have a glass of the best of the week. When I buy it is either wholesale or the best of the inexpensive that I have tasted.