I suppose different people have different triggers in these situations, but I think it's possible, once you've overcome your initial shock, to become more used to things. And I do think certain writers exaggerate the speed with which hardened agents start vomiting all over the place!