Works fine for some stuff, but not for good pipe tobacco. It's the smoldering with restricted air that makes the "flavor" different than either a cigar or cigarette, and it's really tough to "pack" a proper bowl in the usual kinds of beer can bongs.
Maybe if you smoked a whole can full all at once ...(?)