Architects are creating places of worship that also function as civic hubs in a bid to foster connection in the community. But it’s not the answer to everyone’s prayers