There are more doorbell options available to you than you'd expect. The standard ding-dong is the cheapest option, so you'll find that one out in the wild the most. You can request any song you want for the most part though. They just might have to change a note or two for legal reasons. "Would you like to upgrade to almost-Mary had a little lamb for two dollars more?" This doorbell leaves it to dealer's choice. If you're musically gifted, you could really make an entrance.
I would love for some musically gifted pranksters to come by and play a symphony before the person could come to the door to catch them. That's a sweet prank. You have to leave a bag of burning poop though. That's just doorbell-prank etiquette. The victims will be upset if you don't.