If you get crowned on an altar, it becomes a throne which will give you one guaranteed wish, and then has no effect other than to make you feel very comfortable there. Not specified what will happen if the altar is in a temple with a priest tending it.