Churches used to take the breath away as places of worship. Now they do so as magical homes