It might be useful to look at small airplane accidents, since they DO
have stall warning horns. I'm under the impression that stall/spin
accidents are a big cause of fatal accidents also. Do you have any numbers?

I used to own and fly a Cessna 340. That 340 was a great airplane but I
noticed in very rough conditions only in landing configuration I could hear the
stall warning horn. I think it was caused by the stall warning tab being
lifted by the action of a gust or the motion of the airplane to the gust. The
point being, a horn may wake you up, but there are better ways of determining
if you are in a stall. The first time I heard this horn I was landing at
Bishop, CA on a very turbulent day. My reaction was to look at the airspeed
then to do nothing. It got my attention but I was not stalled and it was just
a distraction. Fly the damn airplane for the given conditions. Yes, sometimes
that means a left turn or a right turn and at different speeds. If you cannot
do that please do everyone a favor and get more training until you are
comfortable in either direction.