Evaluating and Improving Causal Reasoning Capabilities in Foundation Models