There's no guaranteed formula, but there is a correlation between payroll and winning, with the Yankees and Dodgers being the prime examples. And as you noted, the Red Sox in particular have done well converting their high-priced acquisitions into championships.
Spending like Cohen did this past offseason is probably just stupid, though.