I had originally used a vuvuzela for the tutorial I wrote for pygame and the accelerometer, it played a vuvuzela note when the n900 was tilted back (effect being to mimic as if it was held up to the mouth and the head tilted back..) In the end I replaced it with a hammer (maeHammer), which plays a hammer noise at the bottom of a hammering movement.

In any case, if you download a vuvuzela sound, you can simply use the tutorial to write python code to play it.. either with a keyboard button (use the left button code from the first maeSpaceShip example) or with the accelerometer and change it to read tilts backwards. Copy and paste the code from the thread into notepad, it's a couple of lines of code changes and less than 5 minutes of work.. might be a nice beginner app