Neural Activation Patterns Across Language Model Architectures: A Comprehensive Analysis of Cognitive Task Performance