While I love ALL the music from Cavalleria Rusticana, I would not consider that music from The Godfather. It's been used to great effect in a number of films, most notably in Raging Bull.
I think my favorite is the waltz, when Vito dances with Connie at her wedding.