I’ve always loved crossbows in games. More so that weapons.
However, the 2handed crossbows rarely felt imposing in those games, perhaps due to how most other weapons tend to be oversized.
Boomerangs are nice as well, a rare sight in most games.
Often available as a special ability, but never as a main weapon.