There is a Pict barbarian in my group who has twice fainted at the sight of monstrosities.
In the first instance, he was confronted by an ape-creature in a scenario similar to Rogues in the House (although, in this instance, the house happened to be on fire as well ... those crazy PCs
). Being a Pict, this seemed entirely appropriate at the time, as he was certain that Gullah had arrived to claim his soul. His offsider, who passed her terror check, but had no intentions whatsoever of taking this thing on, scrambled out a nearby window, dragging her unconscious Pict companion with her. The Pict felt no shame afterwards, given that he had come face to face with his god. In fact, he saw an enraged Gullah in fevered dreams during his stupor, refused to partake in any profits from the entire endeavour, and was merely glad to be alive.
The latter event occured in last night's session, where the PCs encountered a green, humanoid creature of demonic origin emerging from a house carrying a sleeping infant. Later, after the creature was despatched fairly quickly, the group was chatting with the Black Hand of the Inquisition, a remarkably reasonable fellow, despite his rather nasty reputation. This was the second time the group had been found loitering in the vicinity of supernatural events within the space of days, and while Evanthe (the same PC that was with the Pict in the ape encounter) was relating what had occured to the Inquisitor, she mentioned that, "the creature was obviously powerful, as it rendered Akando senseless with merely the power of its gaze". Again, there was no need for the Pict to feel shame, as (either honestly, or by studied ignorance), the event could be layed at the feet of sorcerous power, rather than fear.
The group will hit third level soon enough, and collapsing in terror will cease to be much of an issue. In the meanwhile, it has proved to add to the game, rather than detract from it.
Edit: Oops, 4th before immunity to swooning.