Across two new exhibitions in Los Angeles, the polymath showcases work from the 1980s to the present that reveals a talismanic power