There is almost nothing like a perfectly executed free kick. Everyone in the stadium is staring at you, everyone at home is hoping you will pull through for them.
The environment itself lends to the extreme level of emotion it can bring on, both good and bad. However I personally love when a player throws in a wrench and just completely goes where no one expected, gaining at least a laugh for his dubious efforts.