This may be going off point, but, the melee weapons are a big reason I love Team Fortress 2, as they're not only handy back-ups to your main arsenal, but beyond the standard melee weapons you start off with, all of the unlockable melee weapons have abilities on them that ensure they aren't simply a last resort when your ammo is gone. And some, like the Demoman's 'Eyelander' and 'Scotsman's Skullcutter' the former a broadsword that grants you increased speed via decapitation of your enemies, and the latter a massively powerful albeit slow and heavy battleaxe are designed to be used as primary weapons.
Yet many as you say, still hold on to that sense of superiority of gutting an opponent with ostensibly a weaker or more difficult to use weapon that requires you to be up close and personal. And with TF2, with many of the classes actually being slower than others, a melee kill is even more satisfying, like get a killing blow on a Scout with a Heavy using his fists, glorious!