Hoo boy. I can’t really give you just one or two answers. There are many nice weapons, all for different reasons.
The elven Spear is one. For one reason, it’s one of the few weapons where I’ve found the Veteran illusion to be quite stylish and nice-looking, rather than tacky or nearly unnoticeable. It’s also quite different to use from most other weapons, and historically, spear is the most ubiquitous weapon ever.
While I don’t like to use the Halberd, I like the idea of it (and long weapons in general are nice to have). It’s also one that has quite a fame in reality, even if the in-game usage (or appearance, for that matter) isn’t necessarily too close to that. It’s a Swiss Army weapon - literally.
Axe and Shield feels a bit cumbersome to use in-game (as do shields in general), but it’d likely be my weapon of choice in real life. Games rarely do axes justice as weapons.
There’s also something I like about the asymmetrical dual weapons, especially Victor’s and Markus’s. Those things aren’t easy to use effectively (once again, in reality), but in the context of the game, they work. I just wish the higher-level illusions for Markus’ Mace part of that were less ugly…
And finally, as you rarely see black-powder weapons in fantasy (even if they’re not that rare in Warhammer), I’d say the Handgun. There’s something quite differently stylish about that.
Yeah, there are also other weapons that feel or look nice, despite or in addition to their effectiveness. For a few, I seem to be in the minority for liking. But in all honesty, if I did all the weapons I like for different reasons (and none of it is simply for effectiveness), I’d be listing (nearly) every weapon in the game. As you might’ve noticed, I do have an affinity for real-life comparison, though.