Cause and Effect: Can Large Language Models Truly Understand Causality?