I spent New Year's Eve in Petra last year and our hotel organised a party where they offered wine. Some people complained it was not good wine, but sure if I only spend 20 euros or so for the dinner and drinks I don't expext to be given champagne! I don't remember whether there was beer.
I believe most or virtually all hotels organise New Year's Eve parties for their customers and I don't feel like recommending my own hotel, as that was the worst accommodation of the whole trip.
However, I agree that, if the priority is to drink wine, maybe one should consider a different destination - no intention to be rude, but the more one accepts local customs, the more rewarding his/her trip will be.
Enjoy!