Here is a complete listing of all the shrines in Diablo. Included is the shrine's name, what its effect is, and the message it spits out. It might be handy for you to print out this page, so that you can look at it as you roam the halls of Hell.

Name	Effect	Phrase
Abandoned	+2 to dexterity	The hands of men may be guided by fate
Creepy	+2 to strength	Strength is bolstered by heavenly strength
Cryptic	fills Mana ball; casts Nova Spell from the player	Arcane power brings destruction
Divine	Gives out either 2 full rejuv potions, or 1 full Mana and Healing; fills mana and health balls	Drink and be refreshed
Eerie	+2 to your Magic	Knowledge & Wisdom at the cost of self
Eldritch	Health and Mana potions become rejuvination potions	Crimson and azure become as the sun
Enchanted	One spell goes down a level, all others go up one	Magic is not always what it seems to be
Fascinating	Gives you 2 levels up on Firebolt, but lose 1/10 of your Mana	Intensity comes at the cost of wisdom
Glimmering	All items get indentified	Mysteries revealed in the light of reason
Gloomy	Adds +2 Armor Class to shields, armor, helmets; -1 to weapons max damage	Those who defend seldom attack
Hidden	Adds 10 points to the max and current durability to all items, -10 to one	New strength is forged through destruction
Holy	Teleports you somewhere else on the same level	Wherever you go, there you are
Magical	Casts Mana Shield	While the spirit is vigilant the body thrives
Mysterious	+5 points to random stat, -1 to all others	Some are weakened as one grows strong
Ornate	Holy Bolt +2 levels, but lose 1/10 of your Mana	Salvation comes at the cost of wisdom
Quiet	+2 to Vitality	The essence of life flows from within
Relegious	Repairs all durability	Time cannot diminish the power of steel
Sacred	Charged Bolt +2 levels, but lose 1/10 of your Mana	Energy comes at the cost of wisdom
Secluded	Fills in the map for that level	The way is clear when viewed from above
Spiritual	Fills your inventory with gold	Riches abound when least expected
Spooky	Full rejuvination potions for other players	You: Where avarice fails, patience gains reward Others: Blessed by a benevolent companion
Stone	Recharges staves	The powers of Mana refocused renews
Tainted	Other players get +1-3 random stats, -1 to other	You: Those who are last may yet be first Others: Generosity brings its own rewards
Thaumatugic	All chests on the level regenerate	What once was opened is now closed
Weird	+1 to all weapons maximum damage	The sword of justice is swift and sharp