Just got my mag in the mail yesterday! All the labels in the mag are pretty darn sexy, the Grand Champion's is my fav for sure. The Arcing Amber and Ponzi Steam labels are awesome!
I did most of the labels in Photoshop Elements. I ended up reworking some of the elements a bit after downloading Inkscape (free, woot.). The "pumpkin" ale label was a scanned in ink drawing and then finished all in Photoshop Elements. And yeah, the labels are all printed out on printer sticker sheets.