I've come to like the old all steel Reich "ice cream truck" bells and now have two. Most people can hear them fine and many respond with a smile and a wave. Let's just say that they can't hear me call out a warning very well any more. Both of my bells use their original clamps and they easily fit on the vertical portion of stems on the 4 bikes I use them on. I zip tied a length of inner tube rubber to ID of each clamp to prevent rotation and protect the stem. Each clamp uses a cap screw n allen key to sung the clamp and it only takes a minute or two to install. Just part of the prep for any ride. Bell, tool bag, water bottle, tire pressures. Nice bright chrome on each too.
I see see no reason to drill a hole in a stem.