All three of my bikes have your basic Bell bicycle bell.

This is your stereotypical zzzzzing! zzzzzing! bell. I had tried some smaller single ding bells, but for me it seems more effective to draw out the sound, and this kind of bell does it. For cars and headphone-wearing obliviots I use my AirZound Airhorn "obnoxious blaster" as CankleCat aptly called it.
However, there are those who also value style, elegance and craftsmanship, and for them there are many different avenues, like the beautiful sounding Crane bells and their kind, or the minimalist single, ding bells. And techies favor their web connected, electronic buzzers.
Whatever you choose, it is very cool that you can hear what they sound like on the web and read reviews and get opinions.