It may sound silly, but my favorite off the shelf beer is still Sea Dog blueberry wheat beer. Smooth grainy malt taste up front, but not sweet, leaves the aftertaste of fresh blueberries.
In a bar I'll usually pick up a black and tan (usually a bit of harp and guinness). If I'm going to piss it all out in ten minutes, I'll just drink bud light.