The line between excruciating disappointment and exquisite pleasure can be very thin on the football pitch