Weapons I have used...
I built a character to use a 3.5e sling for one of Cantrip'n's camps, but I was the *only* serious divine caster application, and the build lost 3 caster levels over the progression (Halfling Cleric + PrCs 17/Warblade 1/Adapted Bloodstorm Blade 2), so I eventually changed it out for a Cleric/Holt Warden app. That one used a Club as a hold-out weapon, since it's a legal target for Brambles out of the box.
My E6 build of Panther Totem Barbarian 2/Crusader 4 starts off using a Scimitar + Shield (before he gets Power Attack and while AC still matters), a Glaive (when I wanted a reach weapon), and a Heavy Flail (when I wanted to trip before I got the Improved Trip feat), and it later would probably change over quite well into a Dwarven War Pike.
A build that I've been newly kicking around is the idea of a Halfling Monk that would use Unarmed Strikes. Probably using the Decisive Strike, Invisible Fist, Hin Disciple, and Dark Moon Disciple alterations to make it fit... something. Final build would probably be something like Monk 9/Cleric 1/Sacred Fist 10 or Monk 11/Cleric 1/Sacred Fist 8.
I have made countless "rogues" that use some combination of Daggers, Rapiers, and Hand Crossbows. My favorite was probably a Duergar Psi-Rogue that used Control Light and a Ring of the Darkhidden. I also occasionally make rogues that are not combat-oriented at all, and I give them light crossbows.
I've got another "Rogue" that is more of a Wizard: Rogue 1/Wizard 1/Drow Paragon (3/3 casting) 3/Unseen Seer 5/Swiftblade 10 that will probably use a Longspear later in life.
I've made a typical Cleric Elf Archer once before. Gave him that Longbow Relic that Corellon has.
Sometimes, I make melee Bards. They have solid strength scores and decent attack mods even with ranged weapons, but no free feats for Brutal Throw, so I give them Shortbows as a distance option.
I have conceived of the idea of using 3.5e shuriken on a DSP-Enabled Half-Giant Soulknife (I use the term loosely, since DSP enables Mind Blades to be advanced simultaneously as Manifesting with +1 manifesting PrCs like Slayer). There's a Mind Blade feat that lets you make a full attack with mindblade shuriken, carrying your mindblade enhancements, using Brutal + Power Throw to deal significant damage at a distance. Might have even gotten it to qualify for Ranged Weapon Mastery. I suppose that, technically, he would have used a Bastard Sword, too.
Ah, I also made a Dwarf Fighter that changed out it's racial familiarities to the War Pike and Buckler Axe (allowed, RAW, by Complete Warrior), and used them in conjunction for War Pike awesomeness and threatening adjacent with the Buckler Axe (both of which also benefitted from the Axe Focus feature I picked up, which is why it was marginally better than just Armor Spikes). I believe I was headed towards a Dungeoncrasher / Driving Assault combination with that build, taking full round actions to smack people hard, send them flying (with a Bull Rush modifier in the triple digits), and then crash them into obstacles for more obscene damage with Dungeoncrasher. If they survived, then I would get massive bonuses on a follow-up charge attack thanks to the Shock Trooper tactical. Also, since he was using a War Pike, he could do pretty good with that chain-tripper shtick, too.
Oh, and I used a Glaive for a Xeph Warblade character I had. I was relying on non-Strength modifiers for attack and damage rolls, so my strength was mediocre, but my Attack rolls were still decent, my move speed was really high, and I managed solid damage when I used a maneuver. It was really intended to come into style at a later level, though, and never had the opportunity to fulfill the potential that I wanted for it.