The Holy Visions just add backstory and give XP and a trait point(?). It's more of a place to dump excess gold than anything. It's pretty easy to have 200k in gold by the end of the game. So the altar was added as something to do with excess gold.
It's a bit easier for Clerics to get high volumes of hold as they're not buying every healing potion they come across.