Transformer Models for Automated PII Redaction: A Comprehensive Evaluation Across Diverse Datasets