When you hover over a shrine, its name will be given as an adjective, such as 'creepy' or 'spritual' and when activated will give a clue to its effect. The full list of shrines is below:
Abandoned Shrine
Gives the clue "The hands of men may be guided by fate" and gives a temporary +2 Dexterity increase.
Creepy Shrine
Gives the clue "Strength is bolstered by heavenly faith" and gives a temporary +2 Strength increase
Cryptic Shrine
Gives the clue "Arcane power brings destruction" with the effect of castings a Nova spell and also restores mana.
Divine Shrine
Gives the clue "Drink and be refreshed" with the effect it restores health and mana. Also, on dungeon levels 1-3, it gives one Potion of Full Mana and one Potion of Full Life. On other levels, it gives two Potions of Full Rejuvenation.
Eerie Shrine
Gives the clue "Knowledge and wisdom at the cost of self" and gives a temporary +2 Magic increase.
Eldritch Shrine
Gives the clue "Crimson and Azure become as the sun" with the effect that all potions become rejuvenation potions.
Enchanted Shrine
Gives the clue "Magic is not always what it seems to be" with the effect that the character loses 1 spell level for one spell (2 levels if it is at level 15). All other known spells gain 1 spell level.
Fascinating Shrine
Gives the clue "Intensity comes at the cost of wisdom" with the effect the character loses 10% of base mana and increases the spell Firebolt 2 spell levels.
Glimmering Shrine
Gives the clue "Mysteries are revealed in the light of reason" with the effect all items in your inventory are identified.
Gloomy Shrine
Gives the clue "Those who defend seldom attack" with the effect of giving +2 AC to all armor and -1 max damage to all weapons.
Hidden Shrine
Gives the clue "New strength is forged through destruction" with the effect of bestowing -10 durability to one equipped item and +10 durability to all others equipped. An item will never be destroyed by this effect, even if the penalty reduces the durability to zero.
Holy Shrine
Gives the clue "Wherever you go, there you are" with the effect of casting a Phasing spell.
Magical Shrine
Gives the clue "While the spirit is vigilant the body thrives" with the effect of casting a Mana Shield spell.
Mysterious Shrine
Gives the clue "Some are weakened as one grows strong" with the effect the character receives +5 to one attribute; -1 to all others.
Ornate Shrine
Gives the clue "Salvation comes at the cost of wisdom" with the effect the character loses 10% of base mana and increasing Holy Bolt 2 spell levels.
Quiet Shrine
Gives the clue "The essence of life flows from within" with the effect the character receives a +2 Vitality increase.
Religious Shrine
Gives the clue "Time cannot diminish the power of steel" with the effect of restoring all items to full durability.
Sacred Shrine
Gives the clue "Energy comes at the cost of wisdom" with the effect of the character losing 10% of base mana and increasing Charged Bolt 2 spell levels.
Secluded Shrine
Gives the clue "The way is made clear when viewed from above" with the effect of giving the character a complete map of current level.
Spiritual Shrine
Gives the clue "Riches abound when least expected" with the effect of giving a small amount of gold to each empty slot in your inventory.
Spooky Shrine
Gives the clue "Where avarice fails, patience gains reward" to the person who touches the shrine; other players receive the clue "Blessed by a benevolent companion!". With the effect all other players get life and mana restored but the character touching the shrine receives no benefit.
Stone Shrine
Gives the clue "The powers of mana refocused renews" with the effect of restoring charges in all staves.
Tainted Shrine
Gives the message "Those who are last may yet be first" to the person touching the shrine; other players receive the clue "Generosity brings its own reward". The person touching the shrine is unaffected but other players receive +1 to one attribute and -1 to all other attributes.
Thaumaturgic Shrine
Gives the clue "What once was opened now is closed" with the effect of refilling all chests on current level.
Weird Shrine
Gives the clue "The sword of justice is swift and sharp" with the effect of giving +1 max damage to all weapons in inventory.
---
It should be noted that Thaumaturgic, Weird and Gloomy shrines only appear in single-player games and the effects of Weird and Gloomy shrines only lasts for that game.
Tainted and Spooky shrines only appear in multiplayer games.
An Enchanted shrine can never be found in the Caves or Hell levels of the game, or as an effect of Goat Shrines or Cauldrons.