Emerging Roles of CREB-Regulated Transcription Coactivators in Brain Physiology and Pathology