Actually, for a dwarven bard, I'm thinking bagpipes.
Seriously, it looks like you have a large party, and a bard's usefulness increases with party size. The same is true with the "aura" generators (dragon shaman, marshal, etc.).
Magic missile is a lousy spell for a sorcerer until at least 6th level. Maybe pick the opposite of brawn, since you're already buffing a barbarian for the heavy lifting. Charm person?