The Innocence in D.Gray-Man is the Divine Crystal used as a weapon by Exorcists. As such it is obviously harmful to evil beings... but it can just as well be harmful to the good guys. Parasitic type Exorcists (whose weapon is a part of their own body) are stated to have a short life-span due to the sheer amount of energy it consumes. Also, any Exorcist who forgets his mission will be eaten by the Innocence from the inside, and die after turning into an uncontrollable monster that indiscriminately destroys everything around it for several hours. Finally, non-Exorcists cannot stand being exposed to pure Innocence, even if they aren't evil.
In Scrapped Princess, Ginnungagap is the highest known military grade offensive spell, and is so powerful that it must be sanctioned for use, by way of unanimous decision, by the High Council. The attack itself covers a wide area and is devastating enough on its own, but the real threat is resulting shockwave triggered by it. When used, it caused a mega-tsunami that devastated the majority of the continental coast!
As in the scriptures, the Ark of the Covenant in Raiders of the Lost Ark is an inherently dangerous artifact. Indy and Marion only survive the movie because Indy remembers the Bible saying not to look upon the open Ark. Those Wacky Nazis aren't as lucky.
In Indiana Jones and the Last Crusade, the artifact is the Holy Grail, which isn't deadly itself, but has some rather deadly traps protecting it. (Seeing as the Grail can't be taken from the temple and the eternal life it bestows only lasts so long as you stay there, one has to wonder why such traps are necessary.) Elsa discovers this the hard way when she attempts to take the grail towards the exit and sets off the self-destruct sequence. In a Take My Hand scenario, she obsessively tries to reach for it, despite hanging over an abyss. She falls to her death and Indy almost does the same, until his father tells him to “let it go.”
Dogma uses the idea that God's voice is fatal to mortals as a plot point. It places Metatron (see Mythology, below) in the role of Mr. Exposition, and is used to destroy the renegade angels.
Metatron: Humans possess neither the aural nor the psychological capacity to withstand the awesome power of God's true voice. Were you to hear it, your mind would cave in and your heart would explode within your chest. We went through five Adams before we figured that one out.
The Archangel Michael manifesting at full power strains the fabric of reality nearly to the breaking point.
The True Name of God is so potent that, if not kept in two separate pieces, its raw power would destroy entire universes.
If more than one of the Four Great Treasures of Ireland is kept in the same house without proper preparations, the result would "make a nuclear bomb look like a wet firecracker". The spirit of the Spear Liun, whose element is fire, is particularly temperamental: it wants to burn the evil, darkness, and entropy out of things, and it hurts to look at because entropy is bound to some degree into every living thing.
The Book Of Night With Moon, the book (at least as it appears to humans) that defines the operating parameters of the universe, is described as "blindingly bright" (in a psychic sort of way) and most adult wizards fear the idea of being a conduit for such immense power when someone has to read from it to remind the universe how to behave.
In The Dresden Files, Harry receives the Soulfire power from Archangel Uriel, an ostensibly holy ability that is basically the fires of Creation ... which is powered by his own soul. Though according to Bob, this really isn't as big of a deal as Harry thinks it is. The soul is somewhat malleable, and any portion of his soul that he uses up will eventually come back. So long as he doesn't use Soulfire too much in a short amount of time, he'll be fine. If he does, then as Bob put it, "if you subtract five from five..."
The Silmarils were gems of light that burned everything and everybody trying to touch them who wasn't Incorruptibly Pure.
Eru Ilúvatar, the ultimate Creator, left the Valar in charge of the world to guide and help the humans and Elves. When the Númenoreans decided to declare war on the Valar and invade their land, however, the Valar were unsure what to do and asked Ilúvatar to momentarily take control of the world once again. He responded by immediately sinking the Númenoreans' whole country into the sea, leaving only three ships of faithful survivors.
Earlier in the First Age, when the inhabitants of Middle Earth finally managed to get a messenger across the sea to the Valar to say (paraphrased), "Hey, sorry about that dust-up a couple thousand years back, but there are a lot of innocent people over here who had nothing to do with that, and we could REALLY use some help against the God of Evil. Do a brother a solid?" the Valar came over en masse to kick Morgoth out of creation. The resulting battle sank the better part of the continent into the sea. Wanting to avoid a similar catastrophe is a big part of why they adopted a relatively "hands-off" policy during the War of the Ring.
The Orb of Aldur in The Belgariad will kill anyone who touches it unless they are "pure", which really means "a direct descendant of its last wielder"; purity is In the Blood, apparently. As this line is thought to be extinct, and the danger is well-known, no one has touched the Orb for hundreds of years. The plot of the series kicks off when someone, somehow, manages to steal it.
In VALIS, the narrator notes that Horselover Fat's encounter with God was no better for Fat's sanity than the illegal drugs he used to take. Also, the meeting with God had the side-effect of giving cancer to all Fat's pets. (On the other hand, it's possible that the entity Fat met was not actually God—it's a point that gets debated extensively by the characters, and never completely resolved.)
In The Silver Chair, when Jill Pole first meets Aslan, she asks him if he eats little girls.
"I have swallowed up girls and boys, women and men, kings and emperors, cities and realms," said the Lion. It didn't say this as if it were boasting, nor as if it were sorry, nor as if it were angry. It just said it.
Lewis has his literary avatar encounter this in Perelandra, the second book of The Space Trilogy. Lewis barely manages to fight his way past the fright tactics of harassing demons, to reach a friend's house. There, he sees a beam of unearthly light and hears an inhumanly beautiful voice speaking to him, realizes he is in the presence of an angel ... and is even more terrified. Justified, as the first thing any angel says in the Bible when they show up to talk to someone is, "Do not be afraid."
Angels and demons both have to possess a human in order to walk the Earth. Angels require the consent of the human who is to be their vessel, but just because they're angels doesn't mean it's all going to turn out okay. Many angelic vessels are killed or left broken like victims of bad lobotomies after the angel is finished with them.
When Pamela calls on Castiel to show himself (she's trying to find out who got Dean Winchester out of hell at the beginning of Season Four), he burns her eyes out because humans can't look upon an angel's true form. Did we mention that their true voices shatter glass, shakes buildings and makes your ears bleed?
The Archangel Michael does the same thing to some hapless humans who happen to be sitting in the same bar as Zachariah (a middle-management angel). Unlike Castiel, he doesn't seem to regret it.
Mythology and Religion
This is Older Than Feudalism. In Greek Mythology seeing the undisguised glory of a god would strike mortals dead, as happened to Semele, one of Zeus' many human lovers and the mortal mother of Dionysus.
The Book of Exodus provides the page quote. Moses asks to see God's face. God answers that this would kill Moses, but He does arrange for Moses to see His back instead. Even just His back has the result of Moses' face glowing for several days and having to wear a veil in the meantime.* Funnily enough, worse translations wrote that Moses grew horns from seeing God's back, since the Hebrew word for 'beam', 'keren', is the same as the word for 'horn'. Hence the presence of them on Michelangelo's sculpture of Moses.
The Ark of the Covenant was far too holy for any ordinary person to come in contact with, hence why the priests carried it with poles. Attempting to touch it, even for a good reason, as in the case of the Israelite Uzzah in 1 Samuel who tried to prevent it from falling on the ground, would result in that person being struck dead instantly. One exception is when the Ark resided in the home of Obed-Edom (right after the death of Uzzah), where the Lord blessed his household for the three months that it stayed there.
At another point in 1 Samuel (Chapters 4-7) the Israelites tried to use it as a good luck charm in battle against the Philistines. Its presence ended up galvanizing the Philistines who ripped the Israelites a new one and captured the Ark. Then the Philistines made the mistake of keeping it in the same room as an idol of Dagon, and God destroyed the statue and struck them with a plague of tumors and rats. The Philistine cities started playing hot potato with the thing and eventually decided to send it back to Israel with a guilt offering. Aaaand the Israelites promptly had a whole bunch of people die from looking into the Ark.
Jewish tradition has the archangel Metatronnote meaning "He who stands before the throne" whose job is to be the voice of God, employed any time in the Bible when people hear the voice in the sky. Presumably hearing God's voice is just as dangerous as seeing His face.
Despite warnings from the priests, King Uzziah attempted to burn incense in the temple as a sacrifice to God. God got extremely angry at him for performing a task exclusively reserved for priests and so the king was struck with leprosy.
In St. Paul's First Epistle to the Corinthians, he warns that Communion is not safe for those lacking reverence and holiness. While it gives life to those who have been prepared to approach the Table of the Lord, for those who are not prepared, it brings curses, illness, and can even kill you.
The Islamic version of the aforementioned story about Moses asking to see the face of God/Allah has it that after making a similar warning about the dangers involved, Allah told Moses that He would reveal His Face to a nearby mountain (and only that mountain), so as to let Moses witness what could happen. The result? The mountain is instantly reduced to be as even as the land around it. The implication from other Islamic traditions is that all creations of Allah cannot help but completely humble themselves before His fully unveiled glory, and that what happened to the mountain was the equivalent of an extreme Pose of Supplication. As for Moses, he understandably fainted from the spectacle.
Bhagavadgita has a downplayed version of the theme employed in the three above examples: seeing Krishna's true form, the god Vishnu, does not harm humans (at least, as long as he doesn't mean harm), it just freaks them out real bad.
In later interpretations of Arthurian legend, the Holy Grail tended to be this. Only Sir Galahad, the purest of knights, could survive looking upon it. This might also be said to apply to the Siege Perilous, Galahad's seat at the Round Table, which marked the knight destined to complete the Grail Quest. Anyone other than Galahad who sat in it would immediately die.
In Hawaii, lava rocks and black sand are considered sacred; they are considered to be Pele's "babies." Legend has it that taking them from wherever you find them will awaken Pele's Mama Bear tendencies and bring some kind of bad luck. For this reason, many lava rocks end up being mailed back after those who took them as souvenirs attribute them to whatever misfortunes have befallen them.
The Words of Creation, a precursor tongue to Celestial considered inherently good to the extent that no evil creature can speak them or bear their sound. However, most uses of the Words cause the user to suffer varying amounts of nonlethal damage (for example, speaking another creature's true name inflicts 5d4 damage on the speaker).
The same sourcebook also introduces sanctified spells, which are spells available only to good-aligned spellcasters who prepare spells before casting them. Like the Words of Creation, most are Cast from Hit Points in the form of varying levels of ability damage or, in the case of Eternal Fury, death.
In Warhammer 40,000, astropaths are psykers who make brief psychic contact with the nearly dead God Emperor of Mankind so they can safely use their psychic power for FTL communication. This has the unpleasant side effect of burning out the astropath's eyes.
The White Materia, Holy, is the Planet's ultimate defensive measure. It wipes away anything it judges as a threat to the Planet, which could easily include humanity. Its only thanks to a last-minute intervention by Aerith via the Lifestream that it actually doesn't.
The various WEAPONS (giant monster creatures, not actual swords/guns/etc.) are the backup in case Holy doesn't work. Humanity is right at the top of their "to kill" list, above the Big Bad abominations actively trying to destroy the planet.
Hexen II weaponizes holiness with one of the crusader's weapons. It is a beam of holy light that burns even on the most minor of guilt that exists in all living things.
At the end of Riddle of the Sphinx, clicking on the light from the Ark of the Covenant knocks your character out temporarily.
By implication in Aoi Shiro. The <<Sword>> is a holy object but in addition to being the Key to the Lapis Lazuli Gate it has a corrupting influence on humans and oni alike unless they have enough power to fight off the influnce or the right sort of power to neutralise its effects.
In The Elder Scrolls, the eponymous scrolls are some of the holiest things in existence since they are indestructible divine records of everything that was and will be. Blindness is one of the tamer side effects of reading the Scrolls.
The Zombie Apocalypse that nearly destroys New Tristram in Diablo III is eventually revealed to have been inadvertently caused by the power of Justice: the zombies were the remains of people unjustly killed during previous conflicts between humans and demons, brought back to life because the power of Justice became unregulated after the Archangel of Justice, Tyrael, renounced his position.