Whatever shape you choose, you'll get bubbles - the question is do you want them in one concentrated spot, or spread out?
With the longer airstone, if you have a strong enough air pump, you'll get a little wall of bubbles (I'm thinking of the actual stone, usually blue or green, about 4-5" long - a bubble wall will do the same thing but with finer bubbles). If the pump isn't powerful enough, the bubbles will come out of only the first part, giving you pretty much the same effect as a small cylindrical or spherical airstone.
With the small airstone, if the pump is too powerful you'll get a lot of bubbles concentrated in one place, and a great deal of surface agitation. It's not very pretty, and can splash. If you don't want the bubbles spread out as they would be with the long airstone/bubble wall, you can bleed some of the air off with a valve.
If you've got a small pump, I'd go with the small stone. If it's a larger pump, it's just a matter of personal choice.