The sequel to Part 1. The first one had to do with somethinng that I would find funny in a show, but this one is different.
This one deals with making the audience feel emotional, or get goosebumps. Basically, the music has as much to do with this as the actual scene itself. Therefore, I have created some suggestions for appropriate music.
Funeral - The best song for this situation seems to be "Amazing Grace." Perhaps sung by an adult choir, or something of that nature. Another appropriate song is "Dust in the Wind" by Kansas. However, having Will Ferrell sing this song, with Vince Vaughn saying, "That's what old people do. They die." is not going to get much emotion from the audience.
Now, let's say you want to show some old, sad scenes from a person's childhood. Usually, and I have no clue why, they'll usually show these scenes in black and white. The best music for his situation is "Dream On" by Aerosmith, or "Stairway to Heaven" by Led Zeppelin.
Another way is to have an older character slowly dying from something like cancer, or to have a young kid dying, with the parents standing by in anguish. The classic example of this, in my mind, is Dr. Mark Green on ER. He was dying of something, and as he lay in his hosptial bed near death talking to his family, they played "Somewhere over the Rainbow", which was very effective for them. Another example of music bringing emotion is in Rudy, at the end of the movie when he came on to the football field, and they had the dramatic instrumental music, with the proud parents looking on. That one gets me everytime.
Of course, if you do want something humorous, you can always bring out "Don't Fear the Reaper" by Blue Oyster Cult, with Bruce Dicksinon saying, "I need some more cowbell!", or possibly the best SNL line ever, "I put my pants on the same way you guys do, one leg at a time. The only difference is that when my pants are on, I make gold records." Now that gets me every time.