I love that scence.But the song and the backdrop that's played as the credits role kind of make me sad because i know it's the last time we'd see Dalton as bond and the last time we'd see bond for 6 years.
That's exactly how I used to feel, I was quite young when I saw the film, and was always sad at the point, knowing that was it for Bond, no more (how wrong I was). Also the part just after the explosion of Sanchez, the music that plays (also heard earlier in the film) really makes this scene, Daltons expression when the truck is coming towards him, only to then realize that it's Pam and the relief, you and Bond know it's finally over, he got his revenge, and it's now the end of an era.