Ooh good Q, hmmm, I would have to agree with TB on some accounts in that some things can be an anti-climax.
However, that burning in the pit of your stomach kind of excitement adds to the experience. Although you can experience that without anticipation, if it's part of the waiting it enhances the actual event when it happens.
I think it partly depends on how much the event means to you.