Hm. I'd love to see weapons that aren't as cliche as swords, without being firearms. That said, I'm not a fan of guns in games in general. Unless it's something really unusual. For example, Arcanum, an RPG (that you should play) had a lightning sniper rifle. That was pretty neat.
Hope this isn't getting too off-topic, but one thing that would make me shift way, way further towards the sword side of things? In games, if your weapon has more of an effect than just stats, a gun has more tasks involved. Aiming, reloading, possibly a scope, that sort of thing. It's just more interesting to use. If you have a sword... well, Bethesda games can demonstrate that one. Click, click, click, hit it again. This is why I often go for magic in fantasy RPGs, by the way. Much more fun.
Now, a game with a decent sword-fighting (or just the melee weapon of your choice) system? I'd love to play that. In fact, if anyone knows a game with something like this - say, even, just a fencing mechanic - please let me know.
Aaaand I'd best shut up now. Rambling again, sorry.