I guess if the buzzer is loud and obnoxious enough it's better than
nothing. I only have two problems based on personal experience.
Using the dive brakes without putting the wheel down triggers the
alarm. As it should. On final approach. But also in a crowded thermal,
letting down in the wave, etc. And something could go wrong with one
of the microswitches causing the alarm to scream uncontrollably. Or
the dive brake handle can get knocked away from the sidewall when the
fuselage is in the trailer (if you think having the ELT go off in the
trailer is annoying, try rolling up to the airport Saturday morning to
find that the gear warning horn has been on for days and your battery
is dead.
For all the above reasons, many (most?) people install an override
switch, which invariably you'll forget to switch on again. End of gear
warning.
The second problem is that I've landed with the warning horn going off
in my ear. True, I'd put the wheel down (but hadn't pushed the handle
quite far enough towards the sidewall. I guess subconsciously I knew
there wasn't a problem (and there wasn't) so I subconsciously ignored
the noise. Plus I was finishing low and fast and pulling up and
monitoring traffic and following close on someone's tail in the low
pattern and all sorts of other things at the time. Exactly the kind of
overload situation that might cause me to forget to put the wheel
down.
That was 35 years ago. I haven't had a gear warning system since.
Yeah, I'll probably forget one of these days. And THEN install
one.

But I'm hoping my checklist--which I consult more often with
each passing year--will keep me out of trouble. You can't make things
idiotproof.
Chip Bearden
ASW 24 "JB"
U.S.A.