Just 1 in 4 AI investments bring in the ROI they promise—but CEOs just can’t resist the technology.