As countries spend more trying to alter erratic rainfall patterns with few lasting results, the question of the payoff rises for such investments.