Causal Effect Estimation: Recent Advances, Challenges, and Opportunities