I love how designers of Half-Life balanced the Hivehand. On paper, it's great, it never runs out of ammo, and its projectiles are homing, which enables you to return fire while staying in cover. They balanced it all out by making the Hivehand feel really gross and unsatisfying to use.

It's brilliant!