Of course O'Brien is the guy you would want to have a drink with.  He is the first main character on Trek who is an NCO and not one of those elitist Starfleet Academy snobs.