*shameless plug*
The reason most people don't play bards is that most people don't have the Enchiridion of Mystic Music.
Seriously, I think it's because the bard's "special abilities" (Bardic Knowledge and Bardic Music) don't seem as combat-cool (like the monk's) or diverse (fighter bonus Feats) as other classes.
That said, my favorite PC thus far has been a dwarven bard with while proficiency and a Lash of Saumar (Bastion Press' Alchemy & Herbalists), some of the Alchemical Items from Dragon Magazine's "Better Living Through Alchemy" article, a couple of Bardic Music abilities from the Enchiridion of Mystic Music, and maxxed ranks in Alchemy... always playing with new concoctions and being the sort who kept pulling tricks out of his backside... almost gnomish in personality - except that every "trick" was designed for combat effectiveness/power rather than "look what I can do."
Basically, a chanting, drumming, bagpipe-playing guy with a fetish for alchemist's fire, liquid ice, thunderstones, and other such things. Being gruff and dour, he was every bit the "misunderstood chemistry professor" with a touch of craziness. He took joy in the way alchemical concoctions (mineral stuff) worked.
The rest of the party thought he was a little off his nut - until noticing that even when happily tossing alchemist's fire everywhere, he was scrupulously careful not to catch his friends with "Friendly Fire." Very quickly, they realized that while he might seem loopy, he was just eccentric and an excellent, fiercely loyal companion (and tactician - high Cha, Int and average other attributes).
After all, what more epitomizes the dwarves love of earth and stone and mineral than using those things to wipe out your enemies? Much more fun than a lousy axe or hammer (though these are close seconds).
--The Sigil