A church which has overseen a host of famous names ahead of its multi-million pound transformation has now closed its doors today.